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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.