separate bars in a column chartwith measures

[Kopek]

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 change semantic model, and i am live connected to it, so only measures can be used. so creating a dax table is also not an option in this case...

I have 10 measures, i wans meausre outcome to be my y-axis, and measure name to be my x-axis... any ideas, as i got stuck... 
Now everything is put into one category:

whereas i want something like this where 1,2,3,4,5 is a measuere name

[Kedar_Pande · Accepted solution]

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

[Kopek]

@Kedar_Pande simple as that 🙈 thanks so much!

[Uzi2019]

Hi @Kopek 

Can you share your sample data with expected output???

without having knowledge on you data wont be possible to provide exact solution.