Forum Discussion
Kopek
Helper IV
1 year agoseparate bars in a column chartwith measures
I am having a question on how to separate bars in a column chart when i use measures only. Unpivotting is not an option unfrotunately. What makes it more complicated is the fact i am not allowed to...
- 1 year ago
Click on Enter Data.
Create a table called MeasureNames with a single column for the measure names:
MeasureName
Measure 1
Measure 2
Measure 3
Measure 4.
.
.
Create a Switch Measure:
SelectedMeasureValue =
SWITCH(
SELECTEDVALUE(MeasureNames[MeasureName]),
"Measure 1", [Measure1], // Replace with your actual measure names
"Measure 2", [Measure2],
"Measure 3", [Measure3],
"Measure 4", [Measure4],
BLANK() // Default case if none selected
)Create a new Stacked Column Chart in your report.
Drag MeasureNames[MeasureName] to the Axis area.
Drag the SelectedMeasureValue measure to the Values area.💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn