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.
Hello community!
I am working on a report where I am using ZebraBI card as a visual to depict value of KPI, it's comparison to previous and target period, like so(pic.1):
I also have a slicer on a page, that allows me to change the calculation between MTD, QTD and YTD. It is base on Field parameter.
The issue I have is with formatting, I am setting it in Focus mode like so(pic.2):
Since it is FP, I have to that on QTD and YTD vaules individually, the scenario is:
1. I set it on MTD, it looks ok.
2. I go to QTD, I change it likewise, it looks ok.
3. I go back to MTD and it is straight to entry formatting, with that ".0" again, like it was never changed.
In visualizations pane is set Data Labels to None:
KPI measure is a sum of whole number values, and i itself is also set to:
Does anyone have an idea on how to keep that formatting throughout all FP selections? Let me mention, I want it to be exactly the same between MTD, QTD and YTD, but it mustn't have that decimal values.
If it is not supported then can you suggest what type of native pbi visual would be the best to mimic this exact (or closest possible) layout?
Thanks!
Hello.
I have the same problem. How did you solve it?
Hi @geek_bar ,
Based on the information you provided, you can try the following steps to fix the problem:
If these comments do not help, please provide details of the steps you followed and we can discuss and resolve the issue further.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |