Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

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! 

Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi Anonymous ,

     

    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.

     

     

5 Replies

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi Anonymous ,

     

    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.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        MFelix
        Super User
        5 years ago

        Hi Anonymous ,

         

        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.