Forum Discussion
Parameter Slicer that dynamically changes values on a chart
I have a rough mock up of a chart on a dashboard with the following formula: Adjusted Revenue = SUMX( 'Test Data', SWITCH( TRUE(), 'Test Data'[Type] = "Type A", ...
The data I have used is a simple excel file that has 3 columns, Business Name, Type and Revenue.
I use the clustered column chart on PBI with Business Name on the X axis, Type on the legend and the above measure on the y axis.