Forum Discussion

jayvataliya's avatar
jayvataliya
Frequent Visitor
5 years ago
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    ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    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.

     

     

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

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.

 

 

jayvataliya's avatar
jayvataliya
Frequent Visitor
5 years ago

Great. This is working.

 

Thank you v-yingjl really appreciate your help here.  

 

Anybody who is reading this post, give it a thumbs up 👍