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 have drawn an area chart. How do I remove the colour of the overlapped area? Thank you.
Area in the red lines is the one to be removed:
Any help given is appreciated
Solved! Go to Solution.
Hello @Anonymous ,
Not sure if I understood it right. Basically, you would like to color (or remove color) between two areas. I considered that a calculated column Overlap, which is the minimum of both the main columns on each row can be your answer. Use this calculated column in the area plot and then color this as white (in the format pane, change data color for overlap column).
You can get sample file here:
https://drive.google.com/drive/folders/1gHXGWMFlXGN0Vf-RI8xe6mbiKelLQFou?usp=sharing
Hello @Anonymous ,
Not sure if I understood it right. Basically, you would like to color (or remove color) between two areas. I considered that a calculated column Overlap, which is the minimum of both the main columns on each row can be your answer. Use this calculated column in the area plot and then color this as white (in the format pane, change data color for overlap column).
You can get sample file here:
https://drive.google.com/drive/folders/1gHXGWMFlXGN0Vf-RI8xe6mbiKelLQFou?usp=sharing
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |