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
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
Helpful resources
Power BI Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
