Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello All,
I am continuing work on a workload model for my company. On some of my visuals, I am tracking the top 10 activities of an individual based on a certain time period. Here's the filter criteria:
This filter works great when I am looking at an individual's activities over the whole time period, shown below:
My issue occurs when I use the Multi-Row Card to the left of the graphic to sort the visual by a specific month. The visual keeps the criteria it determined based on TOTAL activities, rather than readjusting the top 10 when I select a specific month. Example below (CERT should be excluded from the visual in the month of March and replaced by somthing else, since this individual did none of that activity in March):
I was wondering if there is a way to use the card, or something similar, to change the dates of the data, while also adjusting what is shown on the visual? If not, it almost seems pointless to keep the month filtering in if I can't see the top 10 activities per month.
I look forward to hearing the community's suggestions!
Solved! Go to Solution.
Replace your multi-row card visual with a slicer on the Year Month column. That will filter the column chart to just the chosen month.
Replace your multi-row card visual with a slicer on the Year Month column. That will filter the column chart to just the chosen month.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
85 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
112 | |
99 | |
69 | |
67 |