Forum Discussion

jongee's avatar
jongee
Frequent Visitor
1 year ago
Solved

Data Matrix fixed column with dynamic date columns

Hi,   I am trying to understand if what I am wanting to achieve is possible within PowerBi. Below is a screenshot of what I want to achieve,                           Below is w...
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi jongee ,

    Sorry for the late response..!!

    I have tried few possible ways and implemented few changes in the attached updated PBIX file.Please go through the attached file.

    If this still doesn't solve the issue, You might consider using the Deneb custom visual to build the report matrix exactly the way you want - one fixed column (e.g. "Score") and dynamic, slicer-controlled date columns next to it.

    If you’re comfortable editing JSON (or using Vega-Lite templates), it could provide a clean, scalable solution to your scenario.

    Thank you.

v-venuppu's avatar
v-venuppu
Community Support
1 year ago

Hi jongee ,

Sorry for the late response..!!

I have tried few possible ways and implemented few changes in the attached updated PBIX file.Please go through the attached file.

If this still doesn't solve the issue, You might consider using the Deneb custom visual to build the report matrix exactly the way you want - one fixed column (e.g. "Score") and dynamic, slicer-controlled date columns next to it.

If you’re comfortable editing JSON (or using Vega-Lite templates), it could provide a clean, scalable solution to your scenario.

Thank you.