Data bars over Rows of a Matrix (instead of values)

[kmp-96]

Hi, I'm looking for a way to add data bars to go across an entire row (i.e. across the Trial SSP in my example) in a Matrix, rather than just comparing each single value between the rows (Furnace (Corrected) Temp, Pre Evap 1 FG Temp etc.).

For a bit of background, the values in this matrix are averages for the following columns in the data table. The matrix is also filtered on one other column ("Line", where this can be "Line 1" or "Line 2").

Is there any way to work around this limitation and set up data bars in this way i.e. creating a table which contains this discrete, averaged data? Thanks in advance.

[amitchandak]

@kmp-96 , not very clear to me. But you can have databar for all required columns

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual#shading-and-font-colors-with...

https://www.tutorialgateway.org/add-data-bars-to-table-in-power-bi/

[kmp-96]

Thanks for your replies @lbendlin @amitchandak.

Apologies for the lack of clarity, I've created a simple version of this in Excel to clarify what I'm looking for.

As of right now, I can only create data bars in the form of the 'Current Table', on a column-by-column basis. I would like to create something along the lines of the 'Desired Table', however one issue is that all of the named columns are individual fields. Is there any way of getting something along these lines?

[v-yiruan-msft · Accepted solution]

Hi @kmp-96 ,

You can try to unpivot the columns(Furnace (Corrected) Temp, Pre Evap 1 FG Temp etc.)) first and put Attribute field onto Columns Fields && Value field onto Values Fields.Unpivot columns

Create matrixBest Regards

Rena

[lbendlin]

You can place two visuals on top of each other and make the background of the "top" visual transparent.