Why does my Power BI card visual have a visual level filter that I cannot remove?

powerbi powerbi-desktop
IronicMuffin picture IronicMuffin · Sep 27, 2018 · Viewed 7.2k times · Source

I have a card visual that I've added to a report. The only other visuals are 3 slicers and a matrix. The slicers are all cleared and the matrix is drilled up all the way.

My card is somehow locked to StoreNumber 1. I haven't set this anywhere and I can't seem to clear it. The card responds to changes in the slicers and matrix, but always filtered by store 1. Help?

enter image description here

Answer

user10899644 picture user10899644 · Jan 11, 2019

I had the same issue (still learning power bi) until I realized that it had to do with the drill down on a report. I could not disable the visual level filter anywhere except on right-clicking on the report and selecting "Drill Up" again.

Related questions

Creating a Measure that returns DISTINCT COUNT by Country and Brand in Power BI

I have a table like below: Country, Advertiser, Brand, Spend C1, A1, B1, 10 C1, A1, B2, 5 C1, A2, B3, 0 C1, A2, B4, 20 C2, A1, B1, 8 C2, A1, B5, 7 C2, A2, B6, 4 C2, A2, B3, 3 C2, A2, B7, 2 C2, A3, B8, 9 …

Read More
Show/Hide column in Power BI Table/Matrix visual

Is there any possibility to show or hide the column in Table/Matrix visual in Power BI report by user dynamically? For Example, I have a table view with columns COLUMN-1, COLUMN-2, COLUMN-3. Now I may have filter drop down …

Read More
Subtract two Date/Time columns in Power BI

How do I subtract two Date/Time columns in Power BI. If I have: How do I find out the time difference between Last Updated and Created Time (in hours)?

Read More