cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RashmitaR Member
Member

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 Super Contributor
Super Contributor

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 Member
Member

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 Super Contributor
Super Contributor

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 Member
Member

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 Super Contributor
Super Contributor

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

@RashmitaR yeah sure if you can, attach PBix file.
ankitpatira Super Contributor
Super Contributor

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 Established Member
Established Member

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 Frequent Visitor
Frequent Visitor

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
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 272 members 2,642 guests
Please welcome our newest community members: