Dynamic Measure Based on Dimension Slicer Selection

[archerjayden]

Hi ,

Is there any method where we can change measure column within horizontal bar chart using dimension slicer. I can’t use key measure disconnected table method. All fields are from same table from SQL Server via direct query mode When Category AMW is selected then I need to calculate countrows(post rating) in Bar Chart and when Category SMP is selected I need to calculate countrows(priority rating) in Bar Chart Please guide

I am attaching sample of what I would want but in Single Slicer selection ! so when anyone selects Franchise AMW then we need to show Visuals on First Page and when other two values of Franchise are Selected then we need to show same visual but switch the measure from Post Value to Rate and vice versa. When All is Selected, can we display a guided message asking users to select AMW or two other values combinedly or separately Is this possible using Calculation Groups? I learnt that it is used for measure variations like for Time Calculations

https://www.dropbox.com/s/9sj26qty4h7haka/Dynamic%20Measure%20Change%20Scenario.pbix?dl=0 

Many Thanks

Archer

[amitchandak]

@archerjayden , I checked the file. Based on what I got seem like you need a measure slicer. Refer these blogs

measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://www.youtube.com/watch?v=vlnx7QUVYME