Forum Discussion
Resolver IPower 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 been asked if I can now alter the output to match the Circuit Breaker Panel format with Even # Breakers on the Left and Odd # on the Right.
- Is there any way to filter Odd / Even
- Do I need to create two seperate Matrix
Any assistance on how to proceed will be much appreciated.
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” )))))))))))))))))))))
3 Replies
- amitchandak
Super User
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
EZimmetI'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
- EZimmet
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” )))))))))))))))))))))
