Slicer to Change Y Axis on Bar Chart between 2 Calculated Columns

[wiselyman3]

Hello, 

I have a bar chart that I want to be able to dynamically change the Y axis between 2 calculated columns I have from seperate tables. The X axis will be staying the same, which are names that are associated with the scores from the calculated columns ("Daily Audit Score" from Table 1 and "Call Audit Score" from Table 2). 

How would I be able to use a slicer to switch the Y axis between Daily Audit Score and Call Audit Score?

[ribisht17 · Accepted solution]

@wiselyman3 

You can use https://endjin.com/blog/2022/06/how-to-dynamically-switch-between-measures-in-power-bi-visuals-with-...

Ritesh,

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users