How to create dynamic date column along with measures using matrix visual in power bi?

[pandeypankaj219]

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? 

[v-stephen-msft · Accepted 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.