Forum Discussion
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
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
8 Replies
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 RecordsThank you so much for the prompt response, but I forgot to mention Region in my question.
Please look at my message once again
