Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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:
After drill down
What it should look like is (edited with paint):
Solved! Go to Solution.
Hi @Anonymous , 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
Hi @Anonymous , 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!
User | Count |
---|---|
80 | |
77 | |
64 | |
48 | |
45 |
User | Count |
---|---|
103 | |
45 | |
39 | |
39 | |
36 |