Change from Stacked Bar Chart to 100% Stacked Bar using a Slicer

[rsbin]

Good Day,

I have the requirement to change from a Stacked Bar visual (SUM of Items) to 100% Stacked Bar visual.

EquipmentID_Count = SUM( GeneralStatistics[Total_EquipmentIDCount] )

I know I can do this via buttons and bookmarks, but for this specific application, my User Group is asking for this to be done via a Slicer Selection (i.e. Select Value or Select % ).   Any ideas would be most appreciated.

Thanks and regards,

[v-jayw-msft · Accepted solution]

Hi @rsbin ,

You could do this by using stacked bar chart.

Step1:

Create a table like below and use it as slicer.

Step2:

Create two measures(simple measures as a demonstration).

_sum = SUM('Table'[value])

_percent = SUM('Table'[value])/CALCULATE(SUM('Table'[value]),ALL('Table'))

Step3:

Create another measure and put it in the visual.

_switch = IF(SELECTEDVALUE(slicer[slicer]) = "sum",slicer[_sum], [_percent])

Best Regards,

Jay

[amitchandak]

@rsbin , You can change measure in visual using measure slicer. But you can not do the same for axis or visual type.

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

You can create a measure like 

divide([measure], calculate([Measure], removefilter(Table[Legend]))  )

replace Legend with Legend column and measure with your measure to get % of  subtotal

Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37

[rsbin]

Hello @amitchandak,

Thanks much for the reply.  I will review the links and see if I can make something work for me.

Appreciate your time.

Regards,