Forum Discussion

jdwalker5's avatar
jdwalker5
Helper II
5 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 ...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    HI jdwalker5 ,

     

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

     

    Thanks,

    Pragati

     

  • Pragati11's avatar
    Pragati11
    5 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

Pragati11's avatar
Pragati11
Super User
5 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
    5 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
      5 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

      • jdwalker5's avatar
        jdwalker5
        Helper II
        4 years ago

        I got it to work but had to limit the small multiples to specific divisions and then group the visuals together.

        It works but feels a little clunky lol.  I appreciate your help, Pragati!