Forum Discussion

jdwalker5's avatar
jdwalker5
Helper II
4 years ago
Solved

Unable to replicate visual

Hello,

 

I'm building out a report to replace something that was built in Tableau.  I'm not having any luck replicating one of the visuals in Power BI.  It looks like a combination of a matrix and a stacked bar chart.  Is there a way to create the below visual in Power BI?

 

 

Need Help
  • Pragati11's avatar
    Pragati11
    4 years ago

    HI jdwalker5 ,

     

    You can use a Stacked Column Chart with Small Multiples. Something like below:

     

    Thanks,

    Pragati

     

  • Pragati11's avatar
    Pragati11
    4 years ago

    HI jdwalker5 ,

     

    Not sure I understand this part of your response- "I need it to only show the regions that had lates instead of all the regions."

    Can you please add more details?

    Also, if possible try sharing some sample data in the form a file. Make sure to remove any sensitive infromation from your sample data. You can upload a file to dropbox and share the link here.

     

    Thanks,

    Pragati

5 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    HI jdwalker5 ,

     

    You can use a Stacked Column Chart with Small Multiples. Something like below:

     

    Thanks,

    Pragati

     

    • jdwalker5's avatar
      jdwalker5
      Helper II
      4 years ago

      Thank you Pragati.  I'm getting much closer with the small multiples you suggested.  The issue I'me having now is the chart is displaying store regions that have no values.  the chart is meant to bucket lates by store divisin and store region.  in the tableau example, each bucket only shows the store regions that had lates.  below is what I'm getting.

       

       

      I need it to only show the regions that had lates instead of all the regions.

       

      FYI, store region is my axis.

      • Pragati11's avatar
        Pragati11
        Super User
        4 years ago

        HI jdwalker5 ,

         

        Not sure I understand this part of your response- "I need it to only show the regions that had lates instead of all the regions."

        Can you please add more details?

        Also, if possible try sharing some sample data in the form a file. Make sure to remove any sensitive infromation from your sample data. You can upload a file to dropbox and share the link here.

         

        Thanks,

        Pragati