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.
Hello,
This is a very unusual request, but I am not able to replicate something that I have already done.
I have a small table with three fields (Unbilled-Recent; Unbilled vPM, Unbilled vPY). As you can see, the two last columns are conditionally formatted. I am not able to replicate this anymore in the new table (if I want to have the same with other values, it doesn't work). It works only if I add a new column with a Period (Month, Quarter, Date, etc.). But if I want to have only values as standalone columns like in this case, it doesn't work (i.e. there is no conditional formatting applied, so arrows do not show up).
Even if I am creating a new table, adding these three measures and try to format them conditionally once again, it doesn't work. 🙂
Can anyone help - what is going on in here?
Below are the formulas:
REGION | PROJEKTNR | PROJEKTNAME | RISK | POC | DELTA | UNBILLED | DEFERRED | DATE01 | PERIOD |
VAST | 123456 | lalaland | 0 | ja | 0% | 0 | 11000 | 3/31/2020 | 03/27/2020 |
VAST | 123457 | whatever | 9888 | ja | 0% | 108000 | 600 | 3/31/2020 | 03/27/2020 |
VAST | 771814 | does | 10000 | ja | 3% | 1000 | 8060 | 2/29/2020 | 02/28/2020 |
NORR | 555444 | not | 90000 | no | 5% | 20000 | 40000 | 2/29/2020 | 02/28/2020 |
NORR | 444311 | matter | 98666 | no | 10% | 40000 | 13333 | 1/31/2020 | 01/31/2020 |
NORR | 111441 | at all | 55000 | no | 22% | 50666 | 50000 | 1/31/2019 | 01/31/2019 |
Solved! Go to Solution.
Hi @Anonymous ,
Please delete all the default rules and then add new rules. Then, it works. Amazing.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Measures are based on context so when you have the calculation of the measure without reference you are filtering it will not return the icons.
It is suggested to add one column to the table. Or you could try to use Card visual with conditional format of background color.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Icey I think I understand, but in the example I pasted it is a table, these are not measures.
So, it is a table with three columns. And it works.
The problem is that when I want to replicate this (i.e. create a new table with the same three columns and use the same conditional formatting), the measures do not appear.
So, accidentally I made this work and I am more than happy, but when I want to use the same methodology in a new project, I am not able to...
Hi @Anonymous ,
If your table visual is made like below, conditional formatting will not work.
I don't know how you can achieve below, because it is logically impossible.
If you don't mind, please create a dummy PBIX file, removing sensitive information and replacing real data, for specific test.
It is suggested to upload the file to OneDrive for Business and then paste the link here.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank you @Icey for spending so much time and trying to help me out.
Below is my pbix, first time i am sharing pbix and first time i am using one drive, hope all is ok 🙂
Hi @Anonymous ,
Oh, I have no access to your file. It is suggested to upload your file to OneDrive for Business and then paste the link here.
Best Regards,
Icey
Hi @Anonymous ,
Please delete all the default rules and then add new rules. Then, it works. Amazing.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank you so much! 🙂
Can you post screen shots of your conditional formatting rule dialogs?
sure, please see below:
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |