Microsoft

Power BI – Dynamic Columns in a Table

Cover Photo 3

In advance Power Bi scenarios , All of us have created dynamic slicers using measures.

the dynamic slicers works on factual values because we use Measures in there.

But what if we want the same slicer to represent Dimensions dynamically?

Well, here is the step by step solution for the same. Without using single DAX Function.

This scenario can be very helpful in migrating reports from other BI tool into Power BI

 

Transform Data :

Click on Transform data

O1

Duplicate the table :

Right click on the table and duplicate the table.

02

 

Rename the table:

Rename the duplicated table to avoid the confusion.

03

Right click on column to Unpivot:

Right click on the column you want the data to be pivoted & click on unpivot Other Columns.

The column you are selecting can be your primary key or unique key. In my data I want the data to be distributed by date so I have selected date Column.

04

Select Unpivot Other Column :

After selection the Unpivot Other Columns, You will see 3 columns

  • Pivoted Column
  • Attribute
  • Value

05

Close and apply changes :

Save your changes that you have made in the table.

06

 

Create a matrix chart :

Pick the pivoted column in Rows Field, Attribute in column Field & Value in values field
07

 

Create a Slicer and pull attributes field :

Create a slicer and pick the attribute column form new table into the slicer.

Select the values from slicer and columns will appear according to selection.

08

Thoughts on “Power BI – Dynamic Columns in a Table”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Ketan Domde

Data Enthusiast Power BI Developer . I share all my best Power BI hacks, tips, and advice to help you deliver in style.

More from this Author

Subscribe to the Weekly Blog Digest:

Sign Up
Follow Us
TwitterLinkedinFacebookYoutubeInstagram