Group by with Two Columns

[BishwaR]

Hi I have a table like this

Region                                Category           Total Day

Asia                                    Expensive             2

North America                   Cheap                  4

Europe                              Very Expensive      5

Ais                                       Very Cheap         1

I have to show these values in one bar graph Region Vs  Group By Category which includes Category+ Today Day.

I can create a group in the Fields section based on Category to include "Expensive","Cheap","Very Expensive" and "Very Cheap" but how to include " Total Day" in the same group so that I can get it all in the Legend

Thank you 

[VahidDM]

Hi @BishwaR 

Do you want something like this:

If yes, use the column chart and set the fiels as below:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

FIFA World Cup - Medal Records 

[BishwaR]

Thank you so much for the prompt response, but I forgot to mention Region in my question.

Please look at my message once again 

[VahidDM]

Can you create your result chart in excel or sketch that on paint (app) and share it with us to be on the same page?

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[BishwaR]

This is what I want in the Bar Graph.

[mussaenda]

What are the values of the Category? How come in Asia region, Expensive is lest than Cheap value? Is it the count of each category by region? I cannot assume that it is the total days because in North America, total days is less compared to other categories.

Please elaborate.

Thank you.

[BishwaR]

I just made up that graph manually in excel for the demo.  It has nothing to do with the table I have posted. Value for the category would be the count of Categories. I am just trying to figure out how can we group two different columns to plot in the Bar Graph. Thank you

[v-yiruan-msft · Accepted solution]

Hi @BishwaR ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want. You can create a visual as below using Clustered Column Chart By Akvelon :

Best Regards

[VahidDM]

Try this:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube