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.
Hi all,
I am working on a dashboard, in which I am trying to implement a KPI visual for current period vs previous period values. The visual works correct for the end date upto 31st December 2016. But when I change my end date to any date from january 2017 KPI visual starts me showing values from 1st january to the selected end date from january 2017.Here I am attaching the
screenshots from the test file.So can any one please help me to find any solution on this..??
Solved! Go to Solution.
That’s just how the KPI visual works. In your case, you can create following two measures to replace the Current sessions and Previous sessions.
Current = CALCULATE ( SUM ( Test[Current sessions] ), ALLSELECTED ( Test[Date] ) )
Previous = CALCULATE ( SUM ( Test[Previouse sessions] ), ALLSELECTED ( Test[Date] ) )
Best Regards,
Herbert
That’s just how the KPI visual works. In your case, you can create following two measures to replace the Current sessions and Previous sessions.
Current = CALCULATE ( SUM ( Test[Current sessions] ), ALLSELECTED ( Test[Date] ) )
Previous = CALCULATE ( SUM ( Test[Previouse sessions] ), ALLSELECTED ( Test[Date] ) )
Best Regards,
Herbert
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |