Trend pivot table with ignoring date filter

[Anonymous]

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?

[amitchandak · Accepted solution]

@Anonymous , I think you have to unpivot column A,B,C and then use them in Matrix

https://radacad.com/pivot-and-unpivot-with-power-bi

[v-yuaj-msft · Accepted solution]

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.

[v-yuaj-msft · Accepted solution]

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.

[amitchandak · Accepted solution]

@Anonymous , I think you have to unpivot column A,B,C and then use them in Matrix

https://radacad.com/pivot-and-unpivot-with-power-bi

[Anonymous · Accepted solution]

Thanks! It works 🙂