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 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you danextian lbendlin for the prompt response.

To keep the Score column fixed and show dynamic date columns in Power BI:

Create a measure: ShowScore = MAX('Sheet1'[Score]).

In the matrix, set Rows: Job Number, Columns: Date.

Add Values: first ShowScore, then Time.

Turn on "Show values in rows" in matrix settings.

Turn off column subtotals for cleaner layout.

This setup keeps Score as a single fixed column and lets you apply conditional formatting on it, while dates remain dynamic.

Thank you.

jongee's avatar
jongee
Frequent Visitor
1 year ago

Thanks for the response. Either I am doing something wrong or what you have suggested doesn't work.

 

 

 

 

 

 

 

 

 

 

 

 

 

I just want the score to be in one column.