Forum Discussion
Gradient colors are not coming for DAX expresions using toggle
Hi, Ferha_Jafri
At present, the only solution I can think of is to manually modify each column individually.
If you have any new ideas, we would be delighted to hear from you.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Ferha_Jafri
I have found two methods for you:
1.Firstly, in the background colour settings, change the style to “rules” and modify it as shown in the image below:
Here is the result after the modification:
2.Secondly, keep the style as “gradient” and add an intermediate value, as shown in the image below:
Here is the result after the modification:
For questions about uploading data, you can try the following links:
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Solved: How to upload PBI in Community - Microsoft Fabric Community
When uploading a file, please be careful to delete sensitive information.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your reply, the above solution which you provided is for # Claims, but what will happen when from Parameter list we will select "Total Premium" or "Total Incurred". The issue is as I mentioned in my previous reply as when we select "Total Premium" or "Total Incurred" or "No. of Claims" then the color variation should happen on the basis of sum_Premium, sum_Incurred, # Claims.
Hi, Ferha_Jafri
At present, the only solution I can think of is to manually modify each column individually.
If you have any new ideas, we would be delighted to hear from you.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.