Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi all
Could you please help me solve this one? Groups C and D have a rolling count of events. The tooltip shows only the event that happened in the selected month. I need it to show all historical events between the start and end date, or if the end date is blank, then today's date, however, only for groups C and D.
Solved! Go to Solution.
Hi,
Finally, I think I've found a solution for your problem.
Please watch the gif below and if you need give me your email and I will send you the pbix.
PS. On the gif I forgot to show this formula
Gif:
Proud to be a Super User!
I can not download the pbix file. Can you share it in other way?
Proud to be a Super User!
I added a new link. I hope this works.
I sent a request to have permition to access the file on one drive
Proud to be a Super User!
please try this link this one works: https://www.dropbox.com/scl/fi/ab0cot16qug1go6d178x7/sample-file.pbix?rlkey=j02c0uagp6liiy8amlhgppff...
On the tooltip page put the measure "Count Event" in the table visual (and after hidden the column if you want).
And with this you will get this tooltip on the Page 1:
Proud to be a Super User!
Thank you. However, this isn't working as expected. The tooltip needs to show the record number matching the value in the cell.
Hi,
Finally, I think I've found a solution for your problem.
Please watch the gif below and if you need give me your email and I will send you the pbix.
PS. On the gif I forgot to show this formula
Gif:
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
79 | |
64 | |
52 | |
48 |
User | Count |
---|---|
217 | |
89 | |
76 | |
67 | |
60 |