Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
@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
@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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 37 | |
| 34 | |
| 31 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 99 | |
| 73 | |
| 66 | |
| 65 |