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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
lukaspocius
Frequent Visitor

Dont show column value in matrix until you drill down

Hello,

I want to represent invoice date when in matrix rows are expanded and you see invoice number and invoice date. Issue is that I need to show either First or Last value when it is not expanded and it can be confusing to end user. How do I show that value as blank until it gets expanded?

 

Current situation:

 

lukaspocius_1-1670852182891.png

After drill down

 

lukaspocius_2-1670852201413.png

What it should look like is (edited with paint):

lukaspocius_3-1670852249917.png

lukaspocius_4-1670852283389.png

 

 

 

1 ACCEPTED SOLUTION
Bifinity_75
Solution Sage
Solution Sage

Hi @lukaspocius , try this:

Earliest date measure = SWITCH(TRUE(),
ISINSCOPE("Your column with data AHA-..."),
max(Table[Earliest date)],""
)


You will have to create a new identical measure for the other date

 

Best regards

View solution in original post

2 REPLIES 2
Bifinity_75
Solution Sage
Solution Sage

Hi @lukaspocius , try this:

Earliest date measure = SWITCH(TRUE(),
ISINSCOPE("Your column with data AHA-..."),
max(Table[Earliest date)],""
)


You will have to create a new identical measure for the other date

 

Best regards

Thank you very much. This is exactly what I needed!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.