Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
coding7
Frequent Visitor

Show the sum of the value group by subscription ID but in graph show only by subscription name

Hi, 

 

I've this graph with Subscription Name and Subscription Id by Amount Cost:

coding7_0-1682600316791.png

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 NameSubscrption IdAmount Cost
Subsciption 1Subscription Id 11412
Subsciption 1 Subscription Id 234
Subsciption 1 Subscription Id 3214
Subsciption 1 Subscription Id 4231
Subsciption 1 Subscription Id 5645



and the graph output desired will be:

Subscription NameAmount Cost
Subsciption 11412
Subsciption 134
Subsciption 1214
Subsciption 1231
Subsciption 1645

 

Can anyone please help me in achieving this?

Thank you!

1 ACCEPTED SOLUTION
v-yueyunzh-msft
Community Support
Community Support

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.

vyueyunzhmsft_0-1683092044688.png

We can set the conditioonal format for the [Amount Cost]:

vyueyunzhmsft_1-1683092075682.pngvyueyunzhmsft_2-1683092091891.png

Then we can get this:

vyueyunzhmsft_3-1683092104289.png

We can close the "Text wrap" in the Format Pane :

vyueyunzhmsft_4-1683092135590.png

Then we can drag our mouse to hide the [Id] column in this visual:

vyueyunzhmsft_5-1683092162105.png

 

 

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

View solution in original post

2 REPLIES 2
v-yueyunzh-msft
Community Support
Community Support

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.

vyueyunzhmsft_0-1683092044688.png

We can set the conditioonal format for the [Amount Cost]:

vyueyunzhmsft_1-1683092075682.pngvyueyunzhmsft_2-1683092091891.png

Then we can get this:

vyueyunzhmsft_3-1683092104289.png

We can close the "Text wrap" in the Format Pane :

vyueyunzhmsft_4-1683092135590.png

Then we can drag our mouse to hide the [Id] column in this visual:

vyueyunzhmsft_5-1683092162105.png

 

 

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 ✌️

coding7_0-1683102128605.png

 

Once again, thanks a lot and kind regards !

 

 

 

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.