Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good morning everyone,
I'm having an issue regarding the conditional formatting of my table based on Slicers selection.
Let's say I have 1 slicer with 3 differents options (X, Y or Z) and a table related to the option selected. Obvisously, my values upon the option selected but it seems I can't apply a conditional formatting into that table for the value specific to the option selected.
The conditional formatting do not care about the option selected and apply the rule for all the wide range of number does not matter if one option or the other is selected.. ? Hope this is clear
If anyone would have any idea to bypass the issue, that would be very thanksful !!
Good morning,
I found the solution to my problem.
Thanks for helping me trying to find the right way to make it work though.
Hi @Anonymous,
Glad to hear that you have worked it out. Would you please kindly share your resolution so that others having similar concern can find the answer more easily.
Thanks,
Yuliana Gu
How is your conditional formatting expression defined? You need to make sure the context transition it is performed and the filter context is taken into account.
You have a detailed explanation in the following article:
https://insightsquest.com/2018/08/18/expression-based-conditional-formatting/
If you still have issues, give us more details about your conditional formatting.
Regards,
Hi @Anonymous,
To make your requirement more clear, please illustrate your scenario with sample data and desired output.
How to Get Your Question Answered Quickly
Regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |