Need Help on Visuals

[anithaMallam]

Hi Team,

               I need help on the usecase/requirement  which is   Sales vs. last year and budget by customer, by market segment, by organization hierarchy, by customer location, across time dimension . For this kind of requirement which visual can i use to display the data so that it will be easy to analyze.

Regards

Anitha

[v-alq-msft]

Hi, @anithaMallam 

Based on your description, you may analyze data from multiple dimension like customer, market segment, organization hierarchy, customer location, time and so on. I'd like to suggest you use matrix visual, which makes it easier to display data meaningfully across multiple dimensions -- it supports a stepped layout. The matrix automatically aggregates the data and enables drill up and drill down.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FarhanAhmed]

HI @anithaMallam 

You can take a look at this article which describes different graphs and their usages in Power BI

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and...

Regards

[amitchandak · Accepted solution]

@anithaMallam , I think Matrix visual. Others are Treemap, Stacked, clustered column bar. But they might not fit in your need.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

Year on Year with or Without Time Intelligence

https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a