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.
Can any one please help in finding an approach to drill through to another report based on the values that are there in matrix visual.
Scenario: I have a matrix visual in one report (say Source report) in below format.
Project Manager | Funding Project | October | November | December | January | February | March | April | May | June | July | August | September |
ABC | 1234 | $1,500 | $900 | $790 | $1,350 | $790 | $900 | $790 | $790 | $1,350 | $1,350 | $1,350 | $1,350 |
All the months are calculted measures and now when I drill through by clicking on the value of october month, it sholud take me to another report to display all the other details that are associated to that particular Project Manager, Funding Project and that particlaur month (October (i.e. $1500) )
The other report should look in this format.
Output:
Category | SubCategory | Sales |
Accessories | Pedals | 400 |
Accessories | Tyres | 600 |
Clothing | Shirts | 500 |
Thanks,
Kalyan
Hi, @Anonymous
You can refer Drillthrough on matrix measure with dax filters and Drill through for calculated measure.
Best Regards,
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |