How to format a row of numbers in Power BI

[wadden0032]

I have a table in my report that looks like this:

I need it to look like this:

I haven't the foggiest idea how to get from "point A to B."😢 I think it has something to do with conditional formatting, but I can't figure out how; seems like Power BI only allows "design" of a table in terms of columns, not rows. Very frustrating!

Failing the ability to highlight the row via a colur field, I could get away with the numbers in the row being itatalized, but I'm at a loss how to do that either. (The highlighted numbers indicte the % percentage change in the row above from the previous period, so must be highlighted in some way.)

Any guidence for this rookie would be appreciated. I'm on an insanely tight deadline for this project and don't have time any longer for "a learning curve!" 😟

[v-luwang-msft]

Hi @wadden0032 

You can try the following steps to  format a row of numbers in Power BI(the following steps is only a sample ，The specific use is adapted to your table and visual)

Step 1,create a color measure:

Measure Value Color = IF(MAX('Table'[Point])<=50,"#ff0000","#000000")

Then:

Then you will see:

More about how to configure color measure,you can see the below:

https://community.powerbi.com/t5/Desktop/Colour-formatting-on-Measure/m-p/864818#M414953

Wish  it is helpful for you!

Best Regard

Lucien Wang

[wadden0032]

Thanks, Lucien. That was a problem for another day, and I'll get back to that to try out your solution. I appreciate the help!

In a similar vein, I think, is todays's problem. I have a table of rankings, as below, that shows a list of cities and how they rank over certain years. How would I just creat a simialar "colour-measure to highlight a specific city based on a slicer selection? This all seems so complicated to me, but I am just learning! 🤔😁

This is how I'd like the table to appear, say, if one were to select Abbotsford–Mission from a slicer:

Again, I appreciate all the wisdom you have to offer! 👍

[v-luwang-msft · Accepted solution]

Hi @wadden0032 

  You want your slicers/filters to not filter all data, but to only highlight the chosen what you selected.

See the below,it may be what you need:

Highlighting with slicer Power BI: https://stackoverflow.com/questions/59930844/highlighting-with-slicer-power-bi

Wish  it is helpful for you!

If you have this problem solved，could you pls my reply as answered，thanks!

Best Regard

Lucien Wang

[amitchandak]

@wadden0032 ,

Create a color measure.

Color Measure =
Switch( True() ,
isblank(max('Table'[office sector])) , "Cyan", /// Or use the coorect color name
"white"
)

and use that is conditional formatting using "field value" option and choose this measure

[wadden0032]

Sounds promising, and I really appreciate your help.

Could you provide me more of a step-by-step process? Don't know how go about creating a "colour measure" or where to do it. Nor am I sure how to specify those 2 rows to apply it, although I'm guessing it has something to do with the "isblank" part of the code you wrote above. Sorry—might seem like a silly question but I really need you to "dumb-it-down" for me. 😉

[amitchandak]

@wadden0032 , I am assuming you are using a year in the Matrix column so conditional formatting for one value will do it for you. Also, those row has a blank value for row's column; so, I created a measure like that.

Refer : https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color-...

This heading and next heading in the link