Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I've this graph with Subscription Name and Subscription Id by Amount Cost:
and I would like to see the subscription name but group by id, so I want to display only Subscrption Name by Amount Cost but with Subscription Id granularity.
For example if I have this table:
Subscription Name | Subscrption Id | Amount Cost |
Subsciption 1 | Subscription Id 1 | 1412 |
Subsciption 1 | Subscription Id 2 | 34 |
Subsciption 1 | Subscription Id 3 | 214 |
Subsciption 1 | Subscription Id 4 | 231 |
Subsciption 1 | Subscription Id 5 | 645 |
and the graph output desired will be:
Subscription Name | Amount Cost |
Subsciption 1 | 1412 |
Subsciption 1 | 34 |
Subsciption 1 | 214 |
Subsciption 1 | 231 |
Subsciption 1 | 645 |
Can anyone please help me in achieving this?
Thank you!
Solved! Go to Solution.
Hi , @coding7
According to your description, you wan to just show the [Subscription Name] in the bar chart .
I test it in my side , there is no option to set the Y-axis Name in bar chart . It will always shwo the curent fields value.
For your need , you can try to use the Table visual.
We can set the conditioonal format for the [Amount Cost]:
Then we can get this:
We can close the "Text wrap" in the Format Pane :
Then we can drag our mouse to hide the [Id] column in this visual:
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @coding7
According to your description, you wan to just show the [Subscription Name] in the bar chart .
I test it in my side , there is no option to set the Y-axis Name in bar chart . It will always shwo the curent fields value.
For your need , you can try to use the Table visual.
We can set the conditioonal format for the [Amount Cost]:
Then we can get this:
We can close the "Text wrap" in the Format Pane :
Then we can drag our mouse to hide the [Id] column in this visual:
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks a lot @v-yueyunzh-msft, I'll customize the table as graph and at least I've a workaround and it will solve the problem ✌️
Once again, thanks a lot and kind regards !
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
189 | |
96 | |
67 | |
63 | |
53 |