Forum Discussion
Helper IHow to get different column data for a slicer from data coming out of two tables
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.
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#M257296 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!
2 Replies
- kentyler
Solution Sage
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
- v-diye-msft
Community Support
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#M257296 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!
