Forum Discussion

MargNIOP's avatar
MargNIOP
Icon for Helper I rankHelper I
2 years ago
Solved

Bar chart in deneb to show the evolution by month

Hello Power BI community

 

I'm trying to build a bar chart in deneb to show the evolution by month of each category, I want to edit the visual to :

 

  • Display the month only if there has been an evolution, currently my visual displays the last month even if there is no evolution. For example, for the job satisfaction category: in October: 2; November: 2; December: 3; January: 3 ==> The tooltip displays October and January, but I'd like to get October and December, as the evolution took place in December not in January
  • I want also to add is the visual a color legend for each month 

 

==> If you have any other visual suggestions, please do not hesitate to share them with me.

 

Thanks a lot 

Here is the pbix  file  : https://drive.google.com/file/d/1Of1AxMxBA4o_7f2zk6mC2y-upOJpJqt9/view?usp=sharing

 

 

 

Please help giammariam  🙂

  • giammariam's avatar
    giammariam
    2 years ago

    I went ahead and added this bit at line 45 to make the colors easily configurable for you. You'll want to include at least as many colors as there are months in your dataset. If you want the visual to pick the colors for you, delete these lines.


    There isn't a limit on the number of months the visual can take. You'll just want to make sure that it's not so many that the visual becomes overcrowded.

     

    .pbix file is attached.

     

    If this is enough to get you going please consider liking this reply and choosing it as the solution. Otherwise, I'm happy to help further.

6 Replies

  • giammariam's avatar
    giammariam
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Hey MargNIOP. Thanks for the tag. Here's a concept that I came up with for this. It has triangle indicators to show changes and it also has the Actual Rates as additional marks (bold for evolutions). Before getting this into Power BI, let me know your thoughts. If you don't like the additional marks, I can remove them.

     

    Here's a gist to see it live.

     

    • MargNIOP's avatar
      MargNIOP
      Icon for Helper I rankHelper I
      2 years ago

      Hello giammariam 

       

      I think it is really good solution we can see if we had an evolution or not and we can compare also the different categories.

       

      Thanks a lot

      • giammariam's avatar
        giammariam
        Icon for Solution Sage rankSolution Sage
        2 years ago

        MargNIOP, I'll get it into Power BI. Before doing that though, do you have a desired color scheme in mind? If so could you provide either the color names, hex values, or rgb values for each month? If you like the current color scheme (gradient blues), I can stick with those.