Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Mjanelle
Regular Visitor

fx feature is not displaying in latest power bi version

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

 

Mjanelle_0-1707837402000.png

 

4 REPLIES 4
PijushRoy
Super User
Super User

Hi @Mjanelle 

In Matrix visual, Fx or conditional formatting option is here
Right click on value column

PijushRoy_0-1707846974607.png


Also, you can find in below option

PijushRoy_1-1707847027881.png

 


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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

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")

PijushRoy_0-1707915210833.png

Now use the measure in value Conditional Formatting in the Field value option

PijushRoy_1-1707915429147.png

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

 

 




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

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? :

Mjanelle_0-1707923094187.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.