Forum Discussion
rank help
Please help
When I select >=4, the visual shows up incorrectly, and it starts at 5
But when I select >3, it shows rigth, please help, is this a bug? TKS
2 Replies
- grazitti_sapnaSuper User
Hi A_aaahuka,
Explanation
- Filter Logic Difference:
- When you select >=4, Power BI includes values equal to 4 and higher.
- If your data does not have a clear boundary or if there is some rounding issue, the visual might start from the next available value (in this case, 5).
- Data Rounding or Formatting:
- If the data is rounded (e.g., decimals rounded to whole numbers), it might exclude 4 because it doesn't exactly match the condition.
- Alternatively, there could be hidden decimals or formatting issues affecting the filtering logic.
Filter Logic for >3:
Selecting >3 might work correctly because it is straightforward, including all values greater than 3.
you can refer to this Link.
If I have resolved your question, please consider marking my post as a solution. Thank you!
- Filter Logic Difference:
- AnonymousNot applicable
Hi A_aaahuka ,
Have you already solved the problem? If so, can you share your solution here and mark the correct answer as standard to help other members find it faster? Thank you very much for your co-operation!
If that doesn't resolve it, try recreating the visualization from scratch, or try downloading the latest version of Power BI Desktop, which often resolves some unexpected situations.
Download link: Download Microsoft Power BI Desktop from Official Microsoft Download CenterIf your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.