Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jongee
Frequent Visitor

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,

Screenshot 2025-07-17 200212.png

 

 

 

 

 

 

 

 

 

 

 

 

 

Below is what I am getting in PowerBI

Screenshot 2025-07-17 203834.png

 

 

 

 

 

 

 

 

 

 

 

 

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?

8 REPLIES 8
v-venuppu
Community Support
Community Support

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. 

v-venuppu
Community Support
Community Support

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.

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

 

Screenshot 2025-07-18 130622.png

 

 

 

 

 

 

 

 

 

 

 

 

jongee_0-1752840480260.png

I just want the score to be in one column.

danextian
Super User
Super User

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





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

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

lbendlin
Super User
Super User

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.

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.