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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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