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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Filtering only visual, not data

Hi all

I have a stacked bar chart and I have some visual level filters.

I'm getting top 3 customer by sum of value. After that i want to add legend by type, but some of my customers type is null. When i filter on visual level filters, top 3 calculation is changing and wrong customers are coming on my chart. Because the logic works as first filter the data and then select the Top 3 customer by value. I don't want this logic.

Here is my example dataset

CustomerTypeValue
AX2
BY3
E 4
CX3
DY2
BY3
C 5
BX1
D 5
AX3
BY2
EX1
C 6

 

 

and example ss for this charts.

 

Screenshot_1.pngScreenshot_2.png


1 ACCEPTED SOLUTION
Anonymous
Not applicable

Create new measure as 
new_mea = CALCULATE(sum(Table1[Value]);all(Table1[Type]))

 

use this measure in top 3 filter instead of sum of value

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Create new measure as 
new_mea = CALCULATE(sum(Table1[Value]);all(Table1[Type]))

 

use this measure in top 3 filter instead of sum of value

v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

 

By my tests, there is no better ways to change that logic.

 

Actually, the filters will be interact with each other.

 

For your scenario, we could see that Type category is bigger than customer category, so it seems that it filter type first then select the Top 3 customer by value.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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