The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
Solved! Go to 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!
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!
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
Help when you know. Ask when you don't!
User | Count |
---|---|
69 | |
67 | |
62 | |
48 | |
28 |
User | Count |
---|---|
112 | |
81 | |
66 | |
54 | |
43 |