Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Community,
I have a graph like below.
And the table looks like this.
How to show qty of each items next to axis on the graph.
For example:
What I expect is the Y axis looks like below.
A (10)
B (5)
C (30)
Thanks in advance.
Solved! Go to Solution.
Hi @DanielLinda ,
Add sort column to tooltips filed of the visual then you can sort the visual by sort column.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @DanielLinda ,
If you are saying to show Amount as bar and Qty as lable next to axis, the answer is no.
However, you might be able to create a calculated column as below to splice Item and Qty column.
Column = 'Table'[Item]&" ("&'Table'[Qty]&")"
Then use this column as y-axis.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-jayw-msft,
It is exactly same graph with what I expected.
I used the calculated column as you created, but when I use the new calculated column.
It didn't work with sort by column option.
I wanted to customized sort so made below table.
Item | Sort |
B | 1 |
D | 2 |
A | 3 |
C | 4 |
E | 5 |
This table has relation(1:*) with main table on Item column.
I want to use Item column to make search box by using slicer.
Is there any way to make the calculated column sorted by the above table?
Thanks.
Hi @DanielLinda ,
Add sort column to tooltips filed of the visual then you can sort the visual by sort column.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@DanielLinda , I assume that you want to show Name and the value together.
Enable Display label and Set Position - Inside Base
That the nearest you can get
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |