cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RashmitaR Helper IV
Helper IV

In line hierarchy levels for drill down in power bi desktop

Hi,  

If I have created a  bar chart using contry,Product,Year , and if I choose the see records options i get to see certain columns in the table which i have not used in the chart.Kindly help me with understanding how is Power Bi selecting Discount band,Month name and Segment column by itself in the table.Please find below snaps for your refernce.

 

Thank you,

Rashmita Reddy.

 

 

 

pic 1.pngpic 2.jpgpic3.jpg

 

pic 4.png 

8 REPLIES 8
ankitpatira Community Champion
Community Champion

Re: In line hierarchy levels for drill down in power bi desktop

@RashmitaR Do you have those extra fields in drill down ? If yes then when you click see records it will show you those fields even though you have not acually drilled down.

RashmitaR Helper IV
Helper IV

Re: In line hierarchy levels for drill down in power bi desktop

@ankitpatira If you can see the above screenshots I have used only Country, Product and Year columns in the chart.My concern is How could Power BI automaticaty take Discount band,Month name and segment.Please let me know if you need further clarification.

Thank you.

ankitpatira Community Champion
Community Champion

Re: In line hierarchy levels for drill down in power bi desktop

@RashmitaR What i meant is have you used Discount Band, month name and segment in drill down? That is where you've specified fields for axis have you also dropped these fields ? See below image. In this case if I select see records i will see records for both Gender and Locality fields.

 

Capture.PNG

RashmitaR Helper IV
Helper IV

Re: In line hierarchy levels for drill down in power bi desktop

@ankitpatira No I have only used Product ,Country and Year in axis and values.If you need I can send u the file so that you can check from your end.

 

pic5.png

ankitpatira Community Champion
Community Champion

Re: In line hierarchy levels for drill down in power bi desktop

@RashmitaR yeah sure if you can, attach PBix file.
ankitpatira Community Champion
Community Champion

Re: In line hierarchy levels for drill down in power bi desktop

@RashmitaR Just tested out with one of the report I had in powerbi desktop. Seems like it is picking up all the text based fields when you see click records. I would use Send a Frown option to submit the issue to microsoft. I can certainly replicate your issue.

Vicky_Song Impactful Individual
Impactful Individual

Re: In line hierarchy levels for drill down in power bi desktop

@RashmitaR, there are no public official documents show the details how the "See Records" feature picks up columns. Looks like@ankitpatira is correct that: "See Records" shows all text columns. I'm checking it with our engineers, will response back once I get any updates.

 

If some unwanted columns are included or wanted columns are missing, you can include or exclude some columns in the Values pane in Visualization. Then, you will get columns exactly what you want when you export data.

 

P2.png

KarineLago Advocate I
Advocate I

Re: In line hierarchy levels for drill down in power bi desktop

Hi @Vicky_Song! Do u have any updates regarding this? Thx!

From Brazil? Go to IntelExcel YT channel https://www.youtube.com/user/Intelxcel to learn Power BI.

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors