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.

lbendlin's avatar
lbendlin
Super User
1 year ago

Put the score under rows and then switch to Tabular layout without subtotals.

 

Note: Any time you have a horizontal scrollbar on a Power BI visual you know that you are trying to do too much.  Power BI is not Excel, you should not try to make it behave like Excel.

jongee's avatar
jongee
Frequent Visitor
1 year ago

This does not give me the required layout. The score is still split over several columns