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

Hi Tahreem24 

 

This does not work...

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Either is a bug OR an issue with your model. It's most probably an issue with the model, some filters applied that generates blank rows. But without the actual model it's hard to debug.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I can't share the data model too bad.

     

    Thanks for your help, I'll look into the data model. :)