DAX - in a matrix visual to count by week (columns) and category (rows)

[isomihai72]

Hi,

I have a visual line and clustered chart as below (measures for periodic and cumulative: current (or plan), actual,forecast.)

I would like to have in a table or matrix visual: rows: (measures) current periodic, current cumulative,actual per,actual **bleep**, forecast per,forecast **bleep**. Columns to be week (as it is above,x-axis...)

---------------------------------------------------------------------

I have a matrix below:

I generate a table "Table_SortOrder" (Enter Data)

Data model:

DAX for 

Dynamic Categories =

    SWITCH(

        TRUE(),

        SELECTEDVALUE('Table_SortOrder'[Category]) = "Current Periodic", [Current Periodic],

        SELECTEDVALUE('Table_SortOrder'[Category]) = "Actual Periodic", [Actual Periodic],

    SELECTEDVALUE('Table_SortOrder'[Category]) = "Forecast Periodic", [Forecast Periodic],

        SELECTEDVALUE('Table_SortOrder'[Category]) = "Current Cumulative", [Current Cumulative],

    SELECTEDVALUE('Table_SortOrder'[Category]) = "Actual Cumulative", [Actual Cumulative],

    SELECTEDVALUE('Table_SortOrder'[Category]) = "Forecast Cumulative", [Forecast Cumulative]

    )

 My problem is that the matrix does not ends as line and clustered column chart (2023-16 - matrix; 2023-18 - line chart)

Any suggestion?

Thank you.

[Anonymous · Accepted solution]

Hi @isomihai72 ,

Based on your description, I created simple data and you can check to see if a filter has been added for the matrix visual.

If the problem persists, could you provide a link to a .pbix file that removes the sensitive data, which could help the problem to be resolved more quickly?

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[isomihai72]

Hi,

thank you for your feedback.

Please see in the posts my feedback.

For my example (containing Current periodic & cumulative in the matrix) it does not works, if I reduced the finish slicer's date...

Best Regards.