Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a clustered bar column which displays a Count of all Customers for Current Year vs Previous Year.
The Counts are filtered by calculated date ranges.
The Counts are accurate only when I show the year of each (highest drill up) on the bar chart.
If I drill down the date heirarchy to the Month level, it shows monthly counts which are almost the equivalent of the yearly counts.
Else the calculations work well on the year to year comparison, but the formula's should also work on the month to month and they are not. See screenshot below... I think this is a visual problem. I am pretty sure my calcs are working properly.
The first value for Current Period is just a field with a COUNT DISTINCT added to it and dropped into the visual.
The second field is calculated using Period Start and End using the formula's below.
Because the first field is just a field with DISTINCTCOUNT, this tells me that the issue is with Power BI and not my calcs...
Please correct me if I am wrong, but I think this is a bug.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@BigPicDeepDive
Really sorry that we are not allowed do that. If so, you may consider open a support ticket in Power BI support. There will be a security method to upload the sample file with issue to do troubleshoot.
Best Regards,
Community Support Team _Caiyun