Forum Discussion

A_aaahuka's avatar
A_aaahuka
New Member
1 year ago

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

  • Hi A_aaahuka,

    Explanation

    1. 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).
    2. 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.
    3. 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!

     

  • Anonymous's avatar
    Anonymous
    Not 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 Center

     

    If 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.