Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
hi Team,
please see extract from my Table visual, what i want to achieve is
if my coloumn attribute = Selected supplier
then highlight the cell in my supplier coloumn with some color
how do i do this? noticed that i can' do this with conditional formatting
Don't know if you still need it but i figured out a bit of a cheat; if you "highlight" text by inserting a rectangle shape with the color fill of your desire, size the rectangle to cover the text you want highlighted, then cut the text box and paste it back (now text will be on top of color recatngle, (depending on your highlight color and color of your text, you'll need toggle with transparency)
Hope this helps;
Currently, there is no other ways other than Conditional Formatting. There is a workaround regards to use conditional formatting on Text field: https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/
You could also vote up the idea of using conditional formating on specifc text.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think i figured it out, buy creating a calculated coloumnt, with if condition and then used a conditional formatting with those values
& it worked like a charm
Regards, vinod
Proud to be a Super User!
i checked for conditional formatting, we cannot do it i think, because conditional formatting is aplicable for numbers or %, not for text
can you let me know, whats your idea of doing it?
if possible can you share a samle?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
111 | |
59 | |
57 |