Combo Chart in Power Bi

[RekhaS]

Hi Folks,

I am new to powerBi Forum as well as to the application, and like to get help as much as possible to understand the tool.

I have a requirement where i have to show a cluster Chart which shows the values of Actuals and Forecast (from 2 different sources) and a Line which shows the Target for each month. Now i have to show the Gap% in Up and Down triangles above the line attached in this screenshot, it was easy on tableau but i am unable to replicate the same on powerb. Please share your inputs Screenshot from Tableau

[Anonymous]

Hi @RekhaS ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[RekhaS]

Hi Xiaoxin,

Attaching a sample data where i have to show the Gap% above the line chart(Target) and Green Bar(Actual) and Orange+Blue(Forecast1+Forecast2) with showing downward & upward triangles for +ve and -Ve values accordingly and labels i have to show for all the metrics

[Anonymous · Accepted solution]

HI @RekhaS,

The default color formatting feature seems not suitable for your request, perhaps you can refer to the following steps if it helps:

1. You can create a unconnected table with three groups. (Actual, forcast1, forcast2)
2. Create a line and stacked column chart with raw table date on x axis, new table group field on column y-axis, Tagert field at the line y-axis. and write a measure formula to redirect to different result based on current value.

dynamic result =
VAR currGroup =
    SELECTEDVALUE ( 'Category'[Group] )
RETURN
    IF (
        [Actual] > 0,
        SWITCH ( currGroup, "Actual", [Actual], "Forecast1", 0, "Forecast2", 0 ),
        SWITCH (
            currGroup,
            "Actual", 0,
            "Forecast1", [Forecast1],
            "Forecast2", [Forecast2]
        )
    )

3. setting these data bar colors.

Regards,

Xiaoxin Sheng

[RekhaS]

Thanks Xiaoxin, but the difficulty i am facing is with Gap% from Target which needs to be shown above the line as Up and Down triangles with -ve and +ve value Gap% value. I have already created the above graphh you have shared. Need help on the Triangle icons on line

[Anonymous]

HI @RekhaS,

>>but the difficulty i am facing is with Gap% from Target which needs to be shown above the line as Up and Down triangles with -ve and +ve value Gap% value. 

I think current power bi should not supported to customize on these data potin icons and let them dynamic changes based on conditions. Perhaps you can submit an idea for this requirement.

Microsoft Power BI ideas

Did you familiar with R/Python scripts? If that is the case, you can also consider using R/Python visuals to script manually plot the chart graph.

Create Power BI visuals using R - Power BI | Microsoft Learn

Create Power BI visuals using Python in Power BI Desktop - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

[RekhaS]

Hello Folks, this is an urgent need , if anyone can advise to acheive the same view in powerbi as screenshot. thanks in advance