Forum Discussion
Data Matrix fixed column with dynamic date columns
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.
Hi jongee ,
I have prepared the .PBIX file as per the requirement.Here's what I have implemented:
Matrix visual with:
Job Number in Rows
Date in Columns
Score shown in a single value per cell via a measure named ShowScore
The ShowScore measure ensures only the score appears in each cell (no extra rows or values like Time).
Dates are spread across the columns, and each row represents a Job Number - exactly as you requested.
Please go through the attached PBIX file for your reference.
Thank you.
Hi,
Thanks for the response and the PBIX file. Unfortunately, it is not what I wanted. I want all the scores shown in one single column and then the time required shown against each date.