Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |