Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
AMBP73
Helper I
Helper I

Card Visuals not Updating with slicers

Hello Everyone,

I have several cards in a report that show values calculated with measures, some as a count and others as a percentage. 

When using slicers with the same column values, the respective cards showin a count won't update, or with cards showing percentage the results are way off?

**This is only happening when using a slicer with the same column values, when using other slicers it works fine**

Could someone please give me insight to what the issue may be? Some google searching suggests tgat it may be because I have used a measure on the cards? But the descriptions do not indicate the exact problem I am having....

Thankyou in advance for any assisstance

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

Hi @AMBP73 ,

I'm guessing that this field is filtered in your measure, for example:

Measure = CALCULATE(AVERAGE('Table'[Column1]),'Table'[Column1] >= 100000)

The code is actually patched in the engine:

Measure = CALCULATE(AVERAGE('Table'[Column1]),FILTER(ALL('Table'[Column1]),'Table'[Column1] >= 100000))

 

The code automatically ignores filtering from 'Table' [Column1].

So soultion is:

Measure = CALCULATE(AVERAGE('Table'[Column1]),FILTER(ALL('Table'[Column1]),'Table'[Column1] >= 100000),VALUES('Table'[Column1]))


Please check the pbix file.

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

View solution in original post

3 REPLIES 3
v-cgao-msft
Community Support
Community Support

Hi @AMBP73 ,

I'm guessing that this field is filtered in your measure, for example:

Measure = CALCULATE(AVERAGE('Table'[Column1]),'Table'[Column1] >= 100000)

The code is actually patched in the engine:

Measure = CALCULATE(AVERAGE('Table'[Column1]),FILTER(ALL('Table'[Column1]),'Table'[Column1] >= 100000))

 

The code automatically ignores filtering from 'Table' [Column1].

So soultion is:

Measure = CALCULATE(AVERAGE('Table'[Column1]),FILTER(ALL('Table'[Column1]),'Table'[Column1] >= 100000),VALUES('Table'[Column1]))


Please check the pbix file.

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

LiamBluett
Frequent Visitor

Hi AMB, are your measures made using the same table that you're filtering? Perhaps it could be an issue with the relations in your data model. I find this is the most common cause of my filtering issues.

Hello Liam,

Thankyou for your response.

Yes, they are from the same table.

In fact, the specific issue relates to a slicer using a specific 'field'  (column) and a card visual using the same 'field (column) within a measure for that card. 

When filtering by another slicer the card visual modify accordingly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors