PowerBI - Dynamic Headers in Table/Matrix Visual

0
votes

Is there a way to dynamically change Table/Matrix visual headers in PowerBI, either using DAX or something else.

Sample data:

enter image description here

So, when it turns to next month the header should be like:

enter image description here

I would highly appreciate your help and support.

Thank you,

1
powerbidaxpowerbi-embedded
Use matrix with only last 3 months in the table. Either limit the number of months when loading data, or apply top N filter on the data to filter out all rows except last 3 months. – Andrey Nikolov

1 Answers

0
votes

Just add Relative date filtering as "in the last 3 months

enter image description here

Just to show "in the last 6 moths" enter image description here