cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BishwaR
Helper V
Helper V

Group by with Two Columns

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 

 

1 ACCEPTED SOLUTION
yingyinr
Community Support
Community Support

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 :

yingyinr_0-1656571320620.png

Best Regards

Community Support Team _ Rena
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

8 REPLIES 8
VahidDM
Super User
Super User

Hi @BishwaR 

 

Do you want something like this:

VahidDM_0-1654729184627.png

 

 

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

VahidDM_1-1654729224867.png

 




 

 

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

Appreciate your Kudos!! 

All logo

LinkedIn | Twitter | Blog | YouTube 

FIFA World Cup - Medal Records 

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

Please look at my message once again 

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!! 

All logo

LinkedIn | Twitter | Blog | YouTube 

This is what I want in the Bar Graph.SAMPLE.jpg

 

 

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.

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

yingyinr
Community Support
Community Support

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 :

yingyinr_0-1656571320620.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Try this:

VahidDM_0-1654822368798.png


 

 

 

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

Appreciate your Kudos!! 

All logo

LinkedIn | Twitter | Blog | YouTube 

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors