Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Creating a combo stacked Bar and Line Graph

Good day!

This is the given data used to create the following combo stacked bar and line graph in Microsoft Excel. Does anyone know how to recreate the same in Power BI? 

 

 

 

Need Help
Show and Tell
Tutorial Requests

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , I think this measure split into both sides.

    For that, you need create a table with dimensions as group bys which you want to filter

     

    examples

     


    union(
    summarize('Table',"Measure","sales","This period",[SALES YTD],"Last period",[SALES LYTD],"POP",[SALES YOY])
    summarize('Table',"Measure","unit","This period",[unit YTD],"Last period",[unit LYTD],"POP",[unit YOY])
    )

     

    or

     

    union(
    summarize('Table',"Measure parent","Measure1","Measure",[Measure1])
    summarize('Table',"Measure parent","Measure2","Measure",[Meausre2])
    )

     

    or


    union(
    summarize('Table',"Measure","App","Last 7 Days",[APP 7 Day],"Last 14 days",[APP 14 days],"last 21 Days",[APP 21 Days])
    summarize('Table',"Measure","App","Last 7 Days",[Leads 7 Day],"Last 14 days",[Leads 14 days],"last 21 Days",[Leads 21 Days])
    )