Create combo chart in Power BI with multiple X-Axis fields

[86010991]

Hello,

Is it possible to create a chart like this in Power BI? 

This was created in Excel using a pivot table with "Deal Status" as the Column (Legend), Forecast Date and Values as the Rows (X-Axis), and filters being Extraction Date and Region. 

Any help/suggestions would be greatly appreciated!!! 

Thank you! 

[MFelix]

Hi @86010991 ,

This is possible making a hierarchy in the X-Axis with the Date  and Values and then use the Deal Status in the legend.

The you just need to drill down to the lowest level:

The PBIX file only have some values but it will work with your modedl that has more lines.

[86010991]

Thank you for this suggestion.  Is it possible to have the Budget be its own column so there are 3 columns shown?  It was only added to "Deal Status" to fit into the Excel chart initially...so it could be its own column in PBI.  

[MFelix · Accepted solution]

Hi @86010991 ,

My bad I have made the incorrect format of the data sample (did not had the values for the Budget) check result attach:

You can use a new column for the renaming instead of looking has FY22 budget.

[v-lionel-msft]

Hi @86010991 ,

It may be necessary to use a custom visual.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@86010991 , I doubt its possible, check clustered stacked visual, if that can help

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001934?tab=overview