cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
shahar26
New Member

Visualization help

Hello all ,

some questions regarding visualization in powerBI desktop :

 

1. Can i add a total column to a graph ? for example show sales by region and the another graph for total ?

 

2.Can i sort a graph showing for example % growth by sales amount without presenting the sales amount?

 

3.is there option to set colors for specific values in all the report ? for example that Red will always be Western Europe in my report?

 

Thank you for your help

Shahar

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-huizhn-msft
Microsoft

Re: Visualization help

Hi @shahar26,

1. If mu understanding is right, you create a bar chart like the following shows. You want to add another bar in the chart to display the total sale, it's impossible to do it, because the y axis value based on the x-axis category(row value in resouce table).

2.PNGsample table    1.PNGbar chart

You can create another chart only including total sum of sales, please see the screenshot below.

3.PNGtotal sum in another chart
2. % growth is a column in your resource table? If it is, and the value is unique, you can the x-axis field, click the "Sort by column" under Modeling->  % growth, more details, please review this blog: Sort by column in Power BI Desktop.

3. Please turn on the "Show all" under data colors, you can set different color for specific value on different bars.

4.PNG

Best Regards,
Angelia

View solution in original post

1 REPLY 1
Microsoft v-huizhn-msft
Microsoft

Re: Visualization help

Hi @shahar26,

1. If mu understanding is right, you create a bar chart like the following shows. You want to add another bar in the chart to display the total sale, it's impossible to do it, because the y axis value based on the x-axis category(row value in resouce table).

2.PNGsample table    1.PNGbar chart

You can create another chart only including total sum of sales, please see the screenshot below.

3.PNGtotal sum in another chart
2. % growth is a column in your resource table? If it is, and the value is unique, you can the x-axis field, click the "Sort by column" under Modeling->  % growth, more details, please review this blog: Sort by column in Power BI Desktop.

3. Please turn on the "Show all" under data colors, you can set different color for specific value on different bars.

4.PNG

Best Regards,
Angelia

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors