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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Possibility of recreating this visual in Power BI (Details in body)

My organization is planning to switch to Power BI eventually for our business intelligence needs, but there are some things we still have not figured out which has left us using our old program.

 

Here is what our current report format looks like

 

possibility.JPG

 

I would like to be able to drill down on the Gross Sales and KPI Margin areas, but those need to be measures in my report. While creating pivot tables (matrix tables) I haven't found a way to put measures in the rows or discovered whether it is even possible to drill down on rows. The "Show on Rows" option in the format section of the visualization pane kind of does what I need, but it shows the measures as totals (which I do not want) 

 

Thank you 

1 ACCEPTED SOLUTION
v-evelk
Employee
Employee

Hello,

 

Check this MS docs article please.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

View solution in original post

1 REPLY 1
v-evelk
Employee
Employee

Hello,

 

Check this MS docs article please.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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