Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
MargNIOP
Helper I
Helper I

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

 

MargNIOP_0-1699103986660.png

 

 

Please help @giammariam  🙂

1 ACCEPTED SOLUTION

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.

giammariam_0-1699124828625.png


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.



Madison Giammaria
Proud to be a Super User 😄
LinkedIn

Do you frequently use Deneb to provide insights to your stakeholders? Have you considered sponsoring this free and open source custom visual? More info here!

View solution in original post

6 REPLIES 6
giammariam
Super User
Super User

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.

giammariam_0-1699107479385.png

 



Madison Giammaria
Proud to be a Super User 😄
LinkedIn

Do you frequently use Deneb to provide insights to your stakeholders? Have you considered sponsoring this free and open source custom visual? More info here!

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

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



Madison Giammaria
Proud to be a Super User 😄
LinkedIn

Do you frequently use Deneb to provide insights to your stakeholders? Have you considered sponsoring this free and open source custom visual? More info here!

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?

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.

giammariam_0-1699124828625.png


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.



Madison Giammaria
Proud to be a Super User 😄
LinkedIn

Do you frequently use Deneb to provide insights to your stakeholders? Have you considered sponsoring this free and open source custom visual? More info here!

That's great, thanks a lot @giammariam 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors