Forum Discussion

EZimmet's avatar
EZimmet
Icon for Resolver I rankResolver I
3 years ago
Solved

Power BI ~ Report Builder formatting

I’ve been tasked with using Report Builder to create Panel Schedules to match Circuit Breaker Panels. Left Image -- I can currently create the output format with no issues. Right Image -- I’ve bee...
Need Help
  • EZimmet's avatar
    EZimmet
    3 years ago

    Found it under the Property section each cell in the row needed to add the formula. did this for each side Odd / Even - TY 

     

    =
    IIF (Fields!CB_Position_.Value = "02", "Black",
    IIF (Fields!CB_Position_.Value = "04", "Black",
    IIF (Fields!CB_Position_.Value = "06", "Black",
    IIF (Fields!CB_Position_.Value = "08", "Black",
    IIF (Fields!CB_Position_.Value = "10", "Black",
    IIF (Fields!CB_Position_.Value = "12", "Black",
    IIF (Fields!CB_Position_.Value = "14", "Black",
    IIF (Fields!CB_Position_.Value = "16", "Black",
    IIF (Fields!CB_Position_.Value = "18", "Black",
    IIF (Fields!CB_Position_.Value = "20", "Black",
    IIF (Fields!CB_Position_.Value = "22", "Black",
    IIF (Fields!CB_Position_.Value = "24", "Black",
    IIF (Fields!CB_Position_.Value = "26", "Black",
    IIF (Fields!CB_Position_.Value = "28", "Black",
    IIF (Fields!CB_Position_.Value = "30", "Black",
    IIF (Fields!CB_Position_.Value = "32", "Black",
    IIF (Fields!CB_Position_.Value = "34", "Black",
    IIF (Fields!CB_Position_.Value = "36", "Black",
    IIF (Fields!CB_Position_.Value = "38", "Black",
    IIF (Fields!CB_Position_.Value = "40", "Black",
    IIF (Fields!CB_Position_.Value = "42", "Black","White” )))))))))))))))))))))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

EZimmet , if that is table visual. As No twice at the start and end. Then create conditional formatting to change the font color to white for the old number using a measure and one measure to change the font color to white for even no

 

I have used the trick to create a matrix view using a table

Power BI How to get two columns format Profit and Loss Statement(P&L) right: https://youtu.be/WLg85yiMgHI

 

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3

EZimmet's avatar
EZimmet
Icon for Resolver I rankResolver I
3 years ago

I've duplicated the Matrix Right & Left [ see image below  ]

Where and how in the Report Builder Tablix Section do i add the conditional filter to change the color.

- TY in advance for the assist