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.
I am trying to create the table below in PBi (without the Ref Target column). I am having 2 issues, but they are linked:
1. Trying to control conditional formatting using DAX. I am currently using the DAX formula below:
Solved! Go to Solution.
Sorry I didn't get a chance to put up some sample data. I was able to figure it out.
First I needed a measure to get the values I needed:
Good afternoon - I am trying to use the logic below, and it appears to work well, but when I go to change the background format to use my new Color measure, its not able to be selected. Any idea what I might be doing wrong?
Solved my issue - Have to set it as a text field. Works great!
Sorry I was late seeing this. Glad you figured it out!
Where are you entering/using this DAX? I was unaware you could control the colors of cells directly with a measure. Could you share an example .pbix of your current setup? Even if you have to fake some data, it would be very useful.
For the bonus point question, what measure(s) are you currently using to fill in this table? Usually just adding +0 to the measure will add a zero instead of a blank to a table.
Hi Cmcmahan, In order to use a measure for conditional formatting, you need to go to the conditional formatting within the formating section of your visual. From there you want to choose Field Value, and then place the measure you are using in the Based on Field. See below:
Hope this helps.
AHH, that's how that is supposed to work. I've always used rules, to format fields.
Could you share some sample data that we can copy/paste? Scrub names/proprietary info if you need to, but figuring out issues (especially with aggregations) is always MUCH easier with a test sample of raw data.
If not, let me know, and I can try and fake up some data that will probably(?) behave the same.
Sorry I didn't get a chance to put up some sample data. I was able to figure it out.
First I needed a measure to get the values I needed:
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |