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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
deeskuma
Frequent Visitor

Custom Measure not working on Pie Chart Visual

Hello Team,

I have created a custom measure , which I want to use as a filter in pie chart visual.
When I apply this filter , it gets applied on the "Legend" but not on the "Values" of the pie chart visual.

Please assist.

Thanks
Deesha

2 REPLIES 2
deeskuma
Frequent Visitor

@Uspace87 
Thanks for the prompt revert !
My exact use case is as follows :
1.The default behaviour of the checkbox slicer in Power BI is that it shows the result of OR when you select multiple items , I wanted to convert checkbox slicer to AND logic upon multiple selection. 

2. I took the help of following link to create a custom measure :

https://radacad.com/slicer-with-and-condition-in-power-bi

3. The custom measure is working correctly on table visual but when I try to use the same on pie chart I am facing the abovementioned issue.

Please suggest if not custom measure then what is the correct way to solve my use case.

Thanks 
Deesha

Uspace87
Resolver III
Resolver III

@deeskuma 

 

Measures cannot be used as filters because filters are used to restrict the data that is displayed in a visual or a report. Filters need to have a fixed set of values that can be used to restrict the data displayed. Measures, on the other hand, are dynamic calculations that change based on the data and filters applied to the report.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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

Top Kudoed Authors