Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi,
I am new to Power BI and trying to develop an report. Below is my requirement.
we want to add different shapes in a single graph for 5 different columns. There are 5 Columns A,B,C,D,E. Cloumns A is the line graph and B,C are also line graphs but dotted which acts as UL and LL for column A. We want shade area between B and C. For column D it should be blod line. For column E it should be traingle/any shape to differentiate all 4 other columns. can you please help me with this.
X axis is time and Y axis is values of the columns(numeric). Below is sample graph. I developed in excel. Orange color is column E which we want to differentiate using any shape.
Depending on the requirements for interactiveness, you should be able to accomplish this with an R visual (either standard or rHTML). I would look into ggplot and the geom_ribbon example:
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |