have all Drill down info in one shot (on top of chart)

[Anonymous]

looking for a way to show all data in chart (not by drill down)

in databse there is category - subcategory- product -subproduct

i need to show all info in chart, how many of prodcut and subproduct sold base on category-subcategory 

look at below photo

in first two column , i have  category - subcategory and in bar there is more info to shw

when mouse over on product , it show sub product info and total sail for it.

[v-lionel-msft]

Hi @Anonymous ,

"when mouse over on product , it show sub product info and total sail for it."

Is this what you want to achieve?

Maybe you can use "tooltips" feature.

Create tooltips based on report pages in Power BI Desktop 

Best regards,
Lionel Chen

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

[Anonymous]

"when mouse over on product , it show sub product info and total sail for it."

my problem is powerbi doesnt group by data by product and sub product!

powerbi allows to add axis (4 filed are added in my sample) , you cant see whole page of item, you shoule drill down to look at new level

let me explain more ,

i have  sub categoryin  and product  in axis.  gategory in legend  and  count of sale  in value ,

so ipowerbi shows me sale-count base on category , it doest breake down sale base on  sub category  , product unless i click on drill down button.

(if you work with tableau , there is mark visualtion, it gives you more featue to breake down data in first sight,

tableau shows sale-count based on category and each category it break down data into sub-categorty then show you product sale in on chart)

look at below photo , each color shows you product-sale (you can add more fields to breake down report)

i hope my explanation was clear!

[v-lionel-msft]

Hi @Anonymous ,

The matrix visual?

Hierarchical data in Power BI is drilled to expand.

Best regards,
Lionel Chen

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

[Greg_Deckler]

Sample data would be extremely helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490