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.
Hi all
I'm trying to conditional format subtotal row but without success. I need to format conditionally in base of the percent presented in each of the time range in the row of the weeks. I don't see how to create diferent rules at the 4 different option of time range.
At the following table I show you how I want to view the color of the values.
The visual at power bi is the following matrix:
Hi @mariannacarbo ,
I am a little confused about your description. Do you want to use Conditional format to determine the different colors of the Subtotal in the screenshot below according to the conditions?
If I understand the error, please point out and provide relevant test data (delete sensitive information) or expected results. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
when you go to CONDIOTIONAL FORMATTING window, on top try applying your rule to TOTALS ONLY, then create a measure to do the subtotals separately and base your formatting based on that field.
If this is not the answer you're seeking, please share more info.
Thanks for your help @sshokri89., but I can't create a specific rule for each one of the different options of range time. I'm showing how I performed this visual:
Any advice?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |