Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Double text value in visuals

Hi   I'm creating Power BI reports on top of a tabular model. I have a column with the following values:   Sales Visit Propspecting Follow up Measurement (blank)   When I put this in a visu...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I found the issue

     

    I had a DAX query like

     

    When Code = A1, the sort order will be 1 for sales visit Sales Visit

    When Code = A2, the sort order will be 2 for sales visit Propspecting

    When Code = A3, the sort order will be 3 for sales visit Follow up

    When Code = A4, the sort order will be 4 for sales visit Measurement

    ELSE sort order is (

     

    Apparently in the DB there was also a code in the DB that was A5, which belonged to sales visit which is why it showed double. Do not know why this was no issue in excel... 

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

If you think it's a buggy behaviour, then open a ticket with MS. It's a looong process and you have to be VERY precise in the description.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Update: I removed all relationships and still have the same issue in Power BI. I think my next step is to open a ticket with MS?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    If you have NO relationships in your model and you put a slicer with just that column and you see two values, it *looks like* a buggy bbehaviour

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yes that is the case

     

    Thanks everyone for your help. I'll update this thread with any updated.