Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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).
You can create another chart only including total sum of sales, please see the screenshot below.
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.
Best Regards,
Angelia
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).
You can create another chart only including total sum of sales, please see the screenshot below.
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.
Best Regards,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |