Forum Discussion

jk100's avatar
jk100
Frequent Visitor
3 years ago
Solved

Display Column Names with Values on Bar Chart

Hi,

I have columns called 'Duration 1' and 'Duration 2' and they contain numeric values. I would like to display the name of the column on the Y-axis directly next to its corresponding bar so the user does not have to use a legend to identify the columns.

 
What is the best way to approach this?

Thank you for you help

Need Help
  • Arul's avatar
    Arul
    3 years ago

    jk100 ,

    try static table approach,

    1. Create a table like this by using enter data option,

    2. Then write two measures for Duration 1 and Duration 2,

    Duration 1 = SUM(YourTablename[ Duration 1])
    Duration 2 = SUM(YourTablename[ Duration 2])

    3. Then write this switch measure to bring the values to the graph,

    Metrics Measure = 
 SWITCH(
     SELECTEDVALUE('Static Table'[Metrics]),
     "Duration 1",[Duration 1],
     "Duration 2",[Duration 2]
    )

    4. Drag the metrics column from static table and the switch measure to the visual,

    Thanks,

    Arul

1 Reply

  • Arul's avatar
    Arul
    Super User
    3 years ago

    jk100 ,

    try static table approach,

    1. Create a table like this by using enter data option,

    2. Then write two measures for Duration 1 and Duration 2,

    Duration 1 = SUM(YourTablename[ Duration 1])
    Duration 2 = SUM(YourTablename[ Duration 2])

    3. Then write this switch measure to bring the values to the graph,

    Metrics Measure = 
 SWITCH(
     SELECTEDVALUE('Static Table'[Metrics]),
     "Duration 1",[Duration 1],
     "Duration 2",[Duration 2]
    )

    4. Drag the metrics column from static table and the switch measure to the visual,

    Thanks,

    Arul