Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Create a visual for previous 6 month on slicer selection

Dear community,
 I have data like this 

  1. I have a table with the columns "Dealer Code," "Sales," and "Invoice Date."

  2. I want to create a matrix visual in Power BI.

  3. In the matrix visual, you want to display the previous six months' names in separate columns.

  4. The matrix visual should not perform any calculations on the sales data because i have simple sales column which i drag and drop in value feild in matrix visual.

  5. Additionally, I want the matrix visual to filter the data based on a slicer selection, where selecting a specific month should display the previous six months' data from the selected month.

To summarize, I want to show the names of the previous six months as separate columns in the matrix visual, without any calculations or aggregations on the sales data. The matrix visual should also filter the data based on a slicer selection of a specific month to display the previous six months' data starting from the selected month.
Please help 

Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
Please show the expected outcome based on the sample data you provided.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors