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

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