topic Re: Bar chart in deneb to show the evolution by month in Custom Visuals Development Discussion

Bar chart in deneb to show the evolution by month

MargNIOP — Sat, 04 Nov 2023 13:20:46 GMT

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 🙂

Re: Bar chart in deneb to show the evolution by month

giammariam — Sat, 04 Nov 2023 19:12:02 GMT

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.

Re: Bar chart in deneb to show the evolution by month

MargNIOP — Sat, 04 Nov 2023 14:27:14 GMT

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

Re: Bar chart in deneb to show the evolution by month

giammariam — Sat, 04 Nov 2023 14:32:48 GMT

@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.

Re: Bar chart in deneb to show the evolution by month

MargNIOP — Sat, 04 Nov 2023 18:01:35 GMT

The gradient blues look good,

Right now, I don't really have a color scheme in mind. Can you show me which part of the code I can edit to change the color if I wish?

How many months does the visual last, please?

Re: Bar chart in deneb to show the evolution by month

giammariam — Sat, 04 Nov 2023 19:11:01 GMT

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.

Re: Bar chart in deneb to show the evolution by month

MargNIOP — Sat, 04 Nov 2023 19:35:46 GMT

That's great, thanks a lot @giammariam