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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
deepwadhwa2823
Regular Visitor

Chart with Multiple dimensions in Power BI

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

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

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

vyangliumsft_0-1710128204556.png

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.

View solution in original post

2 REPLIES 2
deepwadhwa2823
Regular Visitor

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

v-yangliu-msft
Community Support
Community Support

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

vyangliumsft_0-1710128204556.png

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.