Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I'm building a report with a matrix. Behind there are three tables well linked.
Circled in red, I try to hide that date at that level of information. It's a direct reference to a field of the table.
I've try to use a measure, but it worsen the situation by adding references to rows to tables downward.
The best scenario would be to see that dat leveled up. As the one circled in yeallow, it should be at the level of the line 22 instead of 27.
How can I do that?
Solved! Go to Solution.
try use HASONEVALUE in your mensure in date colummn
can you explain your tables and relationships?
try use HASONEVALUE in your mensure in date colummn
Hello @LeandroDeodato ,
I've try that option in a measure. The date is hided, but I have a multiplication or rows related to number of rows found in the next table.
The result is the same ISINSCOPE.
And the date is not a the right place, as pointed in yellow. unless that's something impossible to do.
Do you have any idea how to neutralise that effect?
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
43 | |
42 |