Columns Multiple Dimension Measures in PowerBI

[Anonymous]

Hi everyone,

I working on migrating from Tableau to PowerBI. But I got stuck for multiple dimension.

I have a category, Budget and Revenue, I want to display a chart like below.

But the issue is I cannot click each column to show a detail. I added 1 axis Category and I want to add one more is Budget and Revenue to show filter for Year and Month.

I attached image. Hope to be help . Thank you so much

[ryan_mayu · Accepted solution]

@Anonymous 

maybe you can try select all the columns except budget and revenue in the PQ, then unpivot other columns.

[amitchandak]

@Anonymous , I think the best you can get is like this. Category /year on Axis and both values. With Concatenate Label: Off and Sort on category year

Refer the first screenshot. The second screenshot is just to show the option Concatenate Label: Off 

[Anonymous]

Hi amitchandak,

Your help is great. But I think it's not suit for this case. Using Unpivot Column is better. Thanks for your help

[ryan_mayu · Accepted solution]

@Anonymous 

maybe you can try select all the columns except budget and revenue in the PQ, then unpivot other columns.

[Anonymous]

Hi ryan_mayu, thanks for your help. It worked like a charm. But I have switch from "DirectQuery" to "ImportMode". Is there any issue for that?

By the way, for this case, if I want to add a slicer with "Month" but "Month" column is disappeart after unpivot column, and "Month" is number type, how can we convert it to Text on slicer 
I mean 5 => May , 6 => June

Thanks for your help again

[ryan_mayu · Accepted solution]

@Anonymous 

For the first question, I am sry that I haven't tried the data source as Directquery or import mode. Hoever, you can have a try to see if this solution works or not

For the second question, when you unpivot columns, you need to select month as well.

for the last questions, if you don't have a calendar table, you can create a new column.

Column = SWITCH('Table'[Month],1,"Jan",2,"Feb",3,"Mar",4,"Apr",5,"May",6,"Jun",7,"Jul",8,"Aug",9,"Sep",10,"Oct",11,"Nov",12,"Dec")

 

[Anonymous]

Hi ryan_mayu, I did with ImportMode then it works great. Thanks you so much again. 

You saved my life