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
I have a dashboard set up with CY stats and YOY % change data. Everything is fine until I select a segment on one of my charts. The CY numbers filter down to the selection, but I lose all PY data and YOY & changes? I don't understand what's happening since everything is tied into the same date table? Any ideas?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsPY = CALCULATE([CY Measure],SAMEPERIODLASTYEAR('DateTable'[date]))
The YOY variance is being displayed in a "Card with States by OKViz" so in the setup,
CY measure is placed under "Measure" and PY measure is placed under "Target"
and the display shows the variance. Works fine until I select a segment within the displayed graph.
Hi @Tihannah,
Could you please share some sample file to have a test for you?
Regards,
Daniel He
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 |
---|---|
94 | |
85 | |
84 | |
73 | |
49 |
User | Count |
---|---|
143 | |
132 | |
110 | |
65 | |
55 |