Data Matrix fixed column with dynamic date columns

[jongee]

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 what I am getting in PowerBI

I want the Score column to be only shown once. I need this to be a value so I can apply some conditional formatting. The dates also need to be dynamic as the user will select a date range to view.

Is this possible to have a fixed column?

[v-venuppu]

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.

[jongee]

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. 

[v-venuppu]

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]

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.

[danextian]

Move score to row category. If you put that to Values tile, it will be broken do wn into date and job order.

[jongee]

If I do this then I cannot apply any conditional formatting.

[lbendlin]

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]

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