Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to create a dynamic matrix visual with date columns based on slicer selection and also having measures being used as a column. As if 12 is selected within date day slicer then 12 columns should appear and alongside 5 measure columns should appear within the matrix visual filtered based on row value. How can I implement this using Dax?
Solved! Go to Solution.
Hi @pandeypankaj219 ,
You can put the dates field into the slicer, and when you filter the dates from the slicer, the matrix visual will be dynamically changed based on the slicer.
And also, there's a new feature called field parameters you may try to learn about. Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report.
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
If you're still in doubt, please provide some sample data and expected result.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @pandeypankaj219 ,
You can put the dates field into the slicer, and when you filter the dates from the slicer, the matrix visual will be dynamically changed based on the slicer.
And also, there's a new feature called field parameters you may try to learn about. Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report.
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
If you're still in doubt, please provide some sample data and expected result.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |