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.
Apologies if this is a duplicate post.
I would like to set up conditional formatting, comparing one value in a column to another value in a column (for the same row.) I want to know if Monthly Average Time on a Page is larger than the Yeary Average Time on a Page.
Sample table:
Page | Monthly Average | Yearly Average |
Home Page | 01:32 | 01:28 |
about Page | 00:52 | 01:20 |
Ideally, for the above table, the Monthly Average for "Home Page" would be bold, and the Yearly Average for "About Page" would be bold.
This is more complicated because this is a time value. I'm assuming I would have better luck using the raw decimal data to do the comparison of greater than? The above is correct, but it's formatted to show a correct value.
Solved! Go to Solution.
@Unicorn_Tech Can you please try doing it below if helps you.
Change the time value to below
then create one measure like
below is the ouput
Proud to be a Super User!
@Unicorn_Tech Can you please try doing it below if helps you.
Change the time value to below
then create one measure like
below is the ouput
Proud to be a Super User!
Thank you so much!
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 |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
96 | |
82 | |
72 |