Forum Discussion
Trend pivot table with ignoring date filter
Hello Folks!
I have data source like this:
I plan to use Matrix to produce pivot table like this:
Currently, I can adapt the instruction in PowerBI: Stacked Column Chart using only measures (linkedin.com) to build trend pivot chart with column name like that.
However, I have page filter which is the month of data as well. When I don't select all month, it will show either Feb or March only. I tried to adapt DAX to create calculation like CALCULATE(calculation, ALL(MONTH)) from Removing Page level filter for just 1 visualizatio... - Microsoft Power BI Community. But it's still depending on the page filter. Do you have any solution on that?
Anonymous , I think you have to unpivot column A,B,C and then use them in Matrix
Hi Anonymous ,
Based on your description, I also advise you to unpivot all "A","B"and "C" columns in Power Query Editor and then use it to create a new matrix. What's more, is the date value on the page filter the value in the table you provided above? Is it related to the content of the form you provided? You can try to delete the relationship and create the matrix.
Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Anonymous , I think you have to unpivot column A,B,C and then use them in Matrix
Hi Anonymous ,
Based on your description, I also advise you to unpivot all "A","B"and "C" columns in Power Query Editor and then use it to create a new matrix. What's more, is the date value on the page filter the value in the table you provided above? Is it related to the content of the form you provided? You can try to delete the relationship and create the matrix.
Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.