Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi! I have a table with negative and positive numbers. Depend on the pressed slicer there are 3 types of data: Only positive numbers, only negative numbers and mixed numbers.
You can notice that there is only 1 gradient: from orange (min) to blue (max).
What i need:
Positive numbers- ---> gradient color from light blue to dark blue
Negative numbers ---> gradient color from light orange to dark orange
Is there any way to do that?
-------------------------------------------------
And 1 more question. Is there any visuals to introduce my data like the pic. below
I can see only 1 variant with 3 different visuals filtered by a certain year (pic below)
Solved! Go to Solution.
Hi @rocky777,
Did you try to make the use of the conditional formattin with the diverging colour but placing the 0 in the middle:
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHey,
regarding your second question, give the custom visual "Infographic Designer" a try. You will find it in the marketplace (it's a free visual developed by Microsoft).
This chart
was created by using this settings:
Hope this is what you are looking for.
Regards
Tom
Hi @rocky777,
Did you try to make the use of the conditional formattin with the diverging colour but placing the 0 in the middle:
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you for the answer!!! Any suggestions about the second question?
Hey,
regarding your second question, give the custom visual "Infographic Designer" a try. You will find it in the marketplace (it's a free visual developed by Microsoft).
This chart
was created by using this settings:
Hope this is what you are looking for.
Regards
Tom
Many thanks for your help!!!