Create a visual for previous 6 month on slicer selection
Dear community, I have data like this
I have a table with the columns "Dealer Code," "Sales," and "Invoice Date."
I want to create a matrix visual in Power BI.
In the matrix visual, you want to display the previous six months' names in separate columns.
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.
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