Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I want to drill through by an inactive date:
The red bar values are calculated using USERELATIONSHIP.
The relationship is this:
So when I want to drill through, I want the values in my drill through page to be by E Training Actual Date
I can get one value using MAX, but how do I get all the values for a drill through month?
Many thanks for looking at this.
Hi @laganlee
To better help you, I need to confirm with you your question, do you need to show all the relevant E Training Actual Date dates on the drillthrough page? Are you comfortable sharing your PBIX files?
If I don't misunderstand you, you can try to see if you can get the results you want without DAX, and backup DAX before doing so.
For more information about drillthrough, you can refer to the following documents: Set up drillthrough in Power BI reports - Power BI | Microsoft Learn
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yulia,
Many thanks for that!
I want to drill through to all rows by E Training Date.
That link is very much appreciated, but it unfortunately it does not show how to drill through by an inactive relationship.
Hope that helps with a solution 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
106 | |
87 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |