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

[coding7]

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!

[v-yueyunzh-msft · Accepted 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

[coding7]

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 !