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 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

 



 

 

Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    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

3 Replies

  • Uzi2019's avatar
    Uzi2019
    Icon for Community Champion rankCommunity Champion
    1 year ago

    Hi Kopek 

     

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

     

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

     

     

  • Kedar_Pande's avatar
    Kedar_Pande
    Icon for Super User rankSuper User
    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