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
bcobrien1977
Helper V
Helper V

Show Data Point As A Table with a measure

Hi,

I have a client that loves the show data point as a table feature.  I am a bit frustrated because you create these great measures and can't use them in the show data point as a table.

 

Does anyone have a clever workaround for this or know if Microsoft is planning on adding this?

Visual table and records in Power BI visuals - Power BI | Microsoft Docs

 

Thanks

Brendan

7 REPLIES 7
Jman12
New Member

One way around this is creating a detailed tab which can be in the same layout as the original data and then using the drill through feature - This will work with a measure in your matrix.

axecap
Frequent Visitor

I echo this. I don't fully get why I can see the data behind a table/visual UNTIL I add a measure. I guess this is about measures not being calculated for each row. But surely you should be allowed to see the other data points (and just not show the measure). Frustrating. 

You can experiment with some cross joins and observe how adding a measure changes the outcome. That will give you an idea of the mechanics behind the scenes.

Could you elaborate on what you mean as I'm new to PowerBi, adding a measure changes the outcome of what? I think I'm missing something fundamental here.

What I don't understand is if I have a table of calculated columns, I can see the "data point is a table". But adding a measure disables that? Surely it's the same data underneath and either way, couldn't it just ignore the measure and still show me the data it would have shown before i added the measure

axecap_2-1665486599130.png

Vs

axecap_3-1665486667568.png

I would consider that to be confusing for the report users as it introduces inconsistencies in the UX. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com

bcobrien1977
Helper V
Helper V

Thanks. It makes sense.  It is just tough because you can have a great measure and have to create something else to get to the same number in the data point. 

Thanks for your help. 

lbendlin
Super User
Super User

This is working as designed.  When you look at the data view (second item on the left) you will notice that it also only shows native and calculated columns. Measures depend on filter context which is absent in the "Show data point as table" view.

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Kudoed Authors