How to get different column data for a slicer from data coming out of two tables

[Prash546]

Hello All,

I have slicer created by dim time table having "YTD", "QTD", corresponding to this in another table I have a columns 1.Ytd expln, 2.YTD amt,3.YTD absolute 4.QTD expln, 5.QTD amt 6. QTD absolute.

Now when I want to create a matrix table adding all this 6 columns, when I click on "YTD" in the slicer I should get only columns 1.Ytd expln, 2.YTD amt,3.YTD absolute and when I click "QTD" in the slicer I should get 4.QTD expln, 5.QTD amt 6. QTD absolute.

[v-diye-msft · Accepted solution]

Hi @Prash546 

Sounds like a dynamical column based on the slicer, you might refer to below similar threads for more reference:

https://community.powerbi.com/t5/Desktop/Dynamic-Column-Based-on-Slicer-Selection/m-p/81126 

https://community.powerbi.com/t5/Desktop/Column-Selection-in-matrix-table-visualization/m-p/547264#M... https://community.powerbi.com/t5/Desktop/filtering-fields-to-show/m-p/566713#M267403 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more (share the dummy pbix with expected results would be much appreciated). thanks!

[kentyler]

It sounds like you need to unpivot your table. So that the column headers 1.Ytd expln, 2.YTD amt,3.YTD absolute 4.QTD expln, 5.QTD amt 6. QTD absolute.  become values in a column.

Then you can write a measure or a calculated column to extract the Ytd or QTD part of each value

Then you can create a relationship between your slicer and that column and when you slice by YTD you will get only the YTD values