Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Grouped (or Binned?) Clustered Column Chart

I am trying to replicate the following in Power BI Desktop but cannot find a solution in the community nor on my own.

 

Is there such a thing as 'grouped clustered column' w/ each group having a seperate background color?

 

 

Basically, I want to group my clustered column chart based on a priority attribute in my data. I have a bunch of 'questions' that we answer with a integer value then we give it a priority. We ask, answer, and prioritize these questions annually. I think each question is has the same priority every year. 

 

Questions clustered by year/date then grouped by priority.

 
 
Need Help
Tips and Tricks

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hmm, I did something like this once using stacked visuals.

     

    So, the big colored columns go in the back visual. The front visual is transparent background. You use the same axis for both visuals but turn all the axis labels and such off for the back visual. You just use a static measure like Measure = 30 for the values in the back visual. Set the space between columns to 0 in the back visual. 

     

    It was something along those lines. Kind of a pain. I'll try to dig up the thread or the PBIX if I created one. Or, if you can provide sample data and such I can try to recreate.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        thanks for that example. I'll try to follow your instructions and see if I can figure it out.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      have at it my friend!

       

      QuestionPriorityAnValpit
      Quest384 2020-02
      Quest38452019-06
      Quest125.52019-06
      Quest215.52019-06
      Quest313.252019-06
      Quest4182019-06
      Quest516.752019-06
      Quest6202019-06
      Quest7202019-06
      Quest8342019-06
      Quest946.52019-06
      Quest10202019-06
      Quest11402019-06
      Quest12202019-06
      Quest13402019-06
      Quest14402019-06
      Quest16142019-06
      Quest1527.52019-06
      Quest17202019-06
      Quest1924.752019-06
      Quest20332019-06
      Quest21282019-06
      Quest2233.52019-06
      Quest23172019-06
      Quest2436.52019-06
      Quest25242019-06
      Quest2616.752019-06
      Quest27422019-06
      Quest2835.52019-06
      Quest29252019-06
      Quest30282019-06
      Quest31182019-06
      Quest3245.52019-06
      Quest33202019-06
      Quest34102019-06
      Quest3516.52019-06
      Quest36102019-06
      Quest37372019-06
      Quest3927.252019-06
      Quest40102019-06
      Quest4127.252019-06
      Quest42282019-06
      Quest4336.52019-06
      Quest44132019-06
      Quest45112019-06
      Quest46302019-06
      Quest4722.52019-06
      Quest48242019-06
      Quest49342019-06
      Quest18272019-06
      Quest5027.52019-06
      Quest51342019-06
      Quest5212.52019-06
      Quest53162019-06
      Quest54152019-06
      Quest5546.52019-06
      Quest56312019-06
      Quest57342019-06
      Quest125.52020-02
      Quest2182020-02
      Quest312.252020-02
      Quest417.752020-02
      Quest516.752020-02
      Quest6202020-02
      Quest7202020-02
      Quest8342020-02
      Quest946.52020-02
      Quest10202020-02
      Quest11402020-02
      Quest12202020-02
      Quest13402020-02
      Quest14402020-02
      Quest16142020-02
      Quest1527.52020-02
      Quest17202020-02
      Quest1924.752020-02
      Quest20332020-02
      Quest21282020-02
      Quest2233.52020-02
      Quest23172020-02
      Quest2436.52020-02
      Quest25242020-02
      Quest2616.752020-02
      Quest27422020-02
      Quest2835.52020-02
      Quest29252020-02
      Quest30292020-02
      Quest31182020-02
      Quest3245.52020-02
      Quest33202020-02
      Quest34102020-02
      Quest35172020-02
      Quest36102020-02
      Quest37382020-02
      Quest3927.252020-02
      Quest40102020-02
      Quest4127.252020-02
      Quest42262020-02
      Quest43382020-02
      Quest4415.52020-02
      Quest45172020-02
      Quest4631.52020-02
      Quest4722.52020-02
      Quest48252020-02
      Quest49342020-02
      Quest18272020-02
      Quest5027.52020-02
      Quest51342020-02
      Quest5210.252020-02
      Quest53162020-02
      Quest54162020-02
      Quest5546.52020-02
      Quest56312020-02
      Quest57342020-02
      Quest38452018-07
      Quest125.52018-07
      Quest213.52018-07
      Quest310.752018-07
      Quest4172018-07
      Quest514.752018-07
      Quest6202018-07
      Quest7202018-07
      Quest8342018-07
      Quest946.52018-07
      Quest10202018-07
      Quest11402018-07
      Quest12202018-07
      Quest13402018-07
      Quest14402018-07
      Quest1611.52018-07
      Quest1523.52018-07
      Quest17202018-07
      Quest1924.752018-07
      Quest20332018-07
      Quest21282018-07
      Quest22332018-07
      Quest2314.252018-07
      Quest2436.52018-07
      Quest25222018-07
      Quest2616.252018-07
      Quest27422018-07
      Quest2835.52018-07
      Quest29252018-07
      Quest3025.752018-07
      Quest31142018-07
      Quest3240.52018-07
      Quest33202018-07
      Quest34102018-07
      Quest3516.52018-07
      Quest36102018-07
      Quest37352018-07
      Quest3925.252018-07
      Quest40102018-07
      Quest41252018-07
      Quest42282018-07
      Quest4336.52018-07
      Quest44112018-07
      Quest45102018-07
      Quest46302018-07
      Quest47202018-07
      Quest48232018-07
      Quest49342018-07
      Quest18272018-07
      Quest50232018-07
      Quest51302018-07
      Quest52102018-07
      Quest53162018-07
      Quest54152018-07
      Quest55402018-07
      Quest56332018-07
      Quest57332018-07