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