Forum Discussion
Bar chart - Filter on this Visuals -> basic filtering where value = Measure
Hi jayvataliya
Keep the previous measure and create a visual control measure for each visual and apply it in the visual filter:
visual control_1 = IF ( SELECTEDVALUE ( 'Source table'[FailReason] ) = [Top1 fail], 1 )Please refer the below sample file, hopes it could help.
Hi jayvataliya ,
As I previous post, just adjust the TopN filter as Top1,2,3 for Amount for each bar chart so that you can get the expected output.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hmm, it seems like TopN doesn't work that way.
In the below screenshot, the 2nd chart(2.AAA) shows both the reason instead of only the 2nd fail reason. it is trying to find TOP 2 reasons by the amount.
Hi jayvataliya
Keep the previous measure and create a visual control measure for each visual and apply it in the visual filter:
visual control_1 = IF ( SELECTEDVALUE ( 'Source table'[FailReason] ) = [Top1 fail], 1 )Please refer the below sample file, hopes it could help.
Great. This is working.
Thank you v-yingjl really appreciate your help here.
Anybody who is reading this post, give it a thumbs up 👍