How to create Slicer to select particular columns data (7days,30days,60days)

[Anonymous]

Hi all,

I am new to PowerBI. I have below two tables like supply and demand with same columns :

I have the same columns for demand and supply tables with columns as Id, 7days,30days,60days and 90days.

Basically I have this two fact aggregrated tables from SQL around 2-3M rows each , I just need to use them here for displaying w.r.t slicer, like when selecting 90days , it should show only data related to column of 90days. So I created a 3rd table with columns names and used it in slicer. but I am not getting how to make it connected to this columns name properly. Any Idea?

Screenshot:

Thanks in Advance

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ，

I created a sample pbix file (see attachment), please check whether that is what you want.

1. Select the columns "Last7Days", "Last30Days","Last60Days", "Last90Days" and UNPIVOT these selected columns

= Table.Unpivot(#"Changed Type", {"Last7Days", "Last30Days", "Last60Days", "Last90Days"}, "Date Range", "Value")

2. Create a date range dimension table

3. Create matrix visual (Rows: ID    Columns: Data Range    Values: Value)

Best Regards