Forum Discussion
Creating a combo stacked Bar and Line Graph
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])
)