Forum Discussion
data not getting filtered
Hiii....
i have written two measures
bo<0 = CALCULATE(COUNT('Stock<=1'[FGEX Code]),'Stock<=1'[Current Month BO Qty]=0)
bo>0 = CALCULATE(COUNT('Stock<=1'[FGEX Code]),'Stock<=1'[Current Month BO Qty]>0)
and then prepared pie chart with two measures and prepared the table of fgex code and now when i am clicking on bo<0 in the pie chart the data in the table is not getting filtered
requirement is when we click on bo<0 in pie chart only the bo<0 data should be filtered and displayed in the table
Thank you
2 Replies
Provide sample pbix to test your issue
Hi sarjensystems1 ,
It is not possible to add a measure as chart legend, as measure actually returns a single value. We can only add a column into legend section.
In your scenario, I would suggest you create two separate visuals and use bookmark to work around.
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
