How to show previous months in a visual

[Anonymous]

Hello,

I need some help on this topic.

I have a selected value in the slicer month (8). In the visual I want to show all the month from 1 to 8. What is the best way to show all the data per month in the visual?

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You can create a new measure to judge if the month meets the criteria and use filter to display correct months.

Here is my test file, you can download and refer to it.

[Ashish_Mathur]

Hi,

You may refer to my solution here - Flex a Pivot Table to show data for x months ended a certain user defined month.

Hope this helps.

[Anonymous]

Thanks but I need a solution for PowerBI in Dax

[Ashish_Mathur]

You are welcome.  Open PowerBI desktop and go to File > Import > Excel.  This will bring over all Tables, relationships and measures in PowerBI desktop.