Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic Dimension in bar chart or table

Attached my sample Powerbi and Excel file here 

How we can create dynamic dimesion that change dimension based on slicer selection and change values of dimension as well as fact s from fact table.

In my case I have Dimenstion table that contains ID(unique values), Name, Country, Jobtitle

Fact table that contains ID(unique values), fact column.

 

I need slicer that show as | Country | Job Title | and when i select Country, the chart will show 

  • Country and Facts,

but if i switch to Job title in slicer, the chart will show

  • Job title and facts

Note: 

  1. I am already using Bookmark solution but it takes lots of time to create new bookmark if requirment is changed during run time. I m looking for automated solution so i don't need to worry if dynamic dimestion (column) increased or decreased.
  2. I have alreay tried (unpivot method), it is not efficent since i have more columns in my dimenstion table then i have mentioned here in example, Unpivot method will increase my table size and also reduce the performace.
  3. I am using direct query. If any extra tables need to be created i can get it done in direct query (but not unpivot method)
  4. I tried this ref but could not replicate into my example. please see this link

Thanks, in advance

Kulchandra

3 Replies