Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Community Memebers,
I am new to Power bi Please help here i need to show the average score data against multiple dimensions . Let me know what suitable chart options in power bi where i can show both dimensions together on chart except matrix or tabular view . Any pointer or help would be appreciated !
Regards
Deepak
Solved! Go to Solution.
Hi @deepwadhwa2823 ,
There are many visual in Power BI that can implement multiple dimensions, such as Clustered column chart and Line Chart, where you can place multiple dimensions in X-axis and Value values in Y-axis.
In X-axis, you can place multiple dimensions and display the values of different dimensions by using drill down, Power BI will display the data according to the level of drill down on the visual.
In Y-axis, you can set the aggregation operation on Value, for example, if you want to average the values, you can set Average of value in Value.
Refer to:
Visualization types in Power BI - Power BI | Microsoft Learn
If the visual that comes with Power Bi does not meet your needs, you can click on "Get more visual" to find a customized visual object that meets your needs.
Main sources for acquiring Power BI custom visuals - Power BI | Microsoft Learn
If the above information is not your expected result, if it is convenient, you can express your expected result in the form of a picture or can you provide some sample data in the form of a table or pbix file (without sensitive data), we can better help you!
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the help . One question here Gauge chart. In Qlikview Gauage chart have the option to define segments of different colour . Can we define the same in power BI In Qlikview Gauage chart having 5 segments but any how in power BI i can define 3 segments not more that that. Any lead would be helpful it's urgent
Hi @deepwadhwa2823 ,
There are many visual in Power BI that can implement multiple dimensions, such as Clustered column chart and Line Chart, where you can place multiple dimensions in X-axis and Value values in Y-axis.
In X-axis, you can place multiple dimensions and display the values of different dimensions by using drill down, Power BI will display the data according to the level of drill down on the visual.
In Y-axis, you can set the aggregation operation on Value, for example, if you want to average the values, you can set Average of value in Value.
Refer to:
Visualization types in Power BI - Power BI | Microsoft Learn
If the visual that comes with Power Bi does not meet your needs, you can click on "Get more visual" to find a customized visual object that meets your needs.
Main sources for acquiring Power BI custom visuals - Power BI | Microsoft Learn
If the above information is not your expected result, if it is convenient, you can express your expected result in the form of a picture or can you provide some sample data in the form of a table or pbix file (without sensitive data), we can better help you!
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
15 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
29 | |
3 | |
3 | |
2 | |
2 |