Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am using a card to bring in commentary to my dashboard from an Excel sheet, the dashboard has a filter at Date, Site and Cluster (multiple sites).
This works nicely with numerical data as Clusters are an aggregation of site data so the relationship aggregates the Sites data to report Cluster and Country.
However when it comes to commentary the table will have entries at site, Cluster and Country level in the same table. The commentary works correctly if I use the Site slicer but not for Cluster as the Cluster is related to multiple sites in the table and the Site is the key. I am guessing I need to overcome this with DAX but haven't quite got my head around the filtering and context elements yet!
Any suggestions on how I can bring the commentary into the dashboard at Cluster and UK level using the same filters. A screen shot below hopefully making this clear:
Many thanks in advance.
Hi @wuvane ,
Have you resolved the issue now? If not, please provide your pbix file without privacy information for us to test.
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
87 | |
72 | |
68 | |
64 | |
54 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |