Forum Discussion

RekhaS's avatar
RekhaS
Regular Visitor
2 years ago
Solved

Combo Chart in Power Bi

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 whic...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
RekhaS
Regular Visitor
2 years ago

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's avatar
Anonymous
Not applicable
2 years ago

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