The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am new to PowerBI and trying to learn with some tutorials. I keep seeing everywhere there is now a "FX" button next to most visual customizations. However, this buttong is nowhere to be seen on my version. I have the latest Version: 2.124.2028.0 64-bit (december 2023). I have tried the downloaded version from microsoft's website as well as the app available in Microsoft Store and still no success. I have been searching the internet for a few hours now and no reference to this issue or how to activate it.
The screenshot below if from a simple table, I've tried to switch the visual to a matrix as well and no success. From what I understoof this feature has been released years ago so I'm not sure what's the issue here
Thank you
Hi @Mjanelle
In Matrix visual, Fx or conditional formatting option is here
Right click on value column
Also, you can find in below option
Let me know if that works for you
If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Linkedin
Proud to be a Super User! | |
Hi @PijushRoy ,
Thank you for your reply.
I had noticed the conditional formatting option for the values, but it doesn't apply for an entire line, it would mean that the conditional formatting would need to be replicated on every single column?
Hi @Mjanelle
If you want to create different color for different rows, please create measure
Example
In Below image,
Measure = VAR _region = SELECTEDVALUE(Table[Sales Territory])
RETURN
_region = "Southeast","Blue",
_region = "Southwest","Green",
"Yellow")
Now use the measure in value Conditional Formatting in the Field value option
More info - https://www.mssqltips.com/sqlservertip/6265/power-bi-conditional-formatting-for-matrix-and-table-vis...
If still you have doubts, Please share your requirement screenshot and sample data, it would be helpful
If your requirement is solved, please mark THIS ANSWER as SOLUTION
Proud to be a Super User! | |
My question was more related to see if there was a way to activate the feature that I keep seeing everywhere online except on my workstation. Thank you for your alternative but this is not really what I am looking for, I am trying to add a conditional background on an entire line at a time in a table, not on 1 single cell value. It would be painful to maintain in a table with 10 different columns
Is this a feature that recently disappeared? :