This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hi All
I created a report using multi card , which has 3 values (start, inprogress ,end - as titles ) and have values 22 27 29 , i am not talking about conditional formatting , but i want to have the numbers color coded ( for example 22 balck, 27 red and 29 is green).
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
We cannot achieve that by multi card visual, We can work that out by table visual. Here I create a measuare and use conditional formatting based on the measure as below.
Measure =
SWITCH (
TRUE (),
SUM ( Table1[value] ) = 22, "#b20000",
SUM ( Table1[value] ) = 25, "#ffc04c",
SUM ( Table1[value] ) = 27, "#a500ff",
"#198c19"
)
For more details, please check the pbix as attached.
Regards,
Frank
Hi @Anonymous ,
Based on my test, it is not possible to meet your requirement currently.You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Frank
Thanks how about i do conditional formatting like column value >=0 black, column B >=0 Red......
how and where can i do the conditional formatting?
Thanks
Hi @Anonymous ,
We cannot achieve that by multi card visual, We can work that out by table visual. Here I create a measuare and use conditional formatting based on the measure as below.
Measure =
SWITCH (
TRUE (),
SUM ( Table1[value] ) = 22, "#b20000",
SUM ( Table1[value] ) = 25, "#ffc04c",
SUM ( Table1[value] ) = 27, "#a500ff",
"#198c19"
)
For more details, please check the pbix as attached.
Regards,
Frank
Hi @Anonymous ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
Thanks i need for multicard though. Thanks for the answer and your time greatly appreciate it.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 33 | |
| 26 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 63 | |
| 44 | |
| 28 | |
| 24 | |
| 22 |