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
Anonymous
maybe you can try select all the columns except budget and revenue in the PQ, then unpivot other columns.
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")
Super UserAnonymous
maybe you can try select all the columns except budget and revenue in the PQ, then unpivot other columns.
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
Super UserAnonymous
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")
Super UserAnonymous , 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