Forum Discussion
Solved
Bar chart - Filter on this Visuals -> basic filtering where value = Measure
Hi All, I have a bar chart representing Company and Amount. A, B, C,... is the company name I created a measure that gives me the top 1 fail reason by amount. Eg. Wrong Input ...
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.
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.