Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello! Thank you so much in advance for your time on this post.
I have a chart that shows the count of engaged users over time. I wanted to do a PoP (Period over Period) comparison. To facilitate this, I created a measure that would essentially duplicate the user count and push it into the future by 1 quarter (or) 3 monhts.
** Removing the actual DB names because of confidentiality
measure= CALCULATE(DISTINCTCOUNT(users), PARALLELPERIOD(Date,-3,MONTH))
Now, when I inspect the data of my Viz, I have this:
Year, Qtr Count of users measure Earliest Date
2017,q2 1000 4/1/2017
2017,q3 1500 1000 7/1/2017
2017,q4 1100 1500 10/1/2017
2018, q1 2000 1100 1/1/2018
2018, q2 2200 2000 4/1/2018
2018, q3 2200 7/1/2018
Since we don't have count of users for 2018 q3 (q3 hasn't started yet) I don't want that last portion to appear in my chart.
Right now, I am doing a "dirty fix". I'm checking if the count of users is greater than 0 as a visual level filter.
Is there a better way of doing this?
P.S, I tried attaching images and for some reason, chrome won't work 😐
Thanks again 🙂
Best,
Bharath
Solved! Go to Solution.
Thanks a lot for your help 🙂
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
110 | |
107 | |
92 | |
68 |
User | Count |
---|---|
167 | |
130 | |
129 | |
94 | |
91 |