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 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

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

6 Replies

  • RekhaS's avatar
    RekhaS
    Regular Visitor
    2 years ago

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

    • RekhaS's avatar
      RekhaS
      Regular Visitor
      2 years ago

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