Forum Discussion

RyanThorsen's avatar
RyanThorsen
Frequent Visitor
2 years ago
Solved

Small Multiples chart

How can I get rid of blank values in a bar chart. I used small multiples and this is what I get     But I want this   
  • lbendlin's avatar
    lbendlin
    2 years ago

    Expand the Territory/Region hierarchy.

RyanThorsen's avatar
RyanThorsen
Frequent Visitor
2 years ago

Thanks, that worked to get me the view, but last thing, can I adjust bar colors based on a column. Particularly the Region color in this dummy data?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Please provide sample data that fully covers your issue.
    Please show the expected outcome based on the sample data you provided.

    • RyanThorsen's avatar
      RyanThorsen
      Frequent Visitor
      2 years ago

      The smaple data does fully cover what i'm trying to do. with that sample data i was able to build this visual in Tableau. I'd like to get the same viz in Power BI

       

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        Ah so you want random colors? Why?