Forum Discussion

Kopek's avatar
Kopek
Icon for Helper IV rankHelper IV
1 year ago
Solved

separate 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...
  • Kedar_Pande's avatar
    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