Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 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
7 years ago

There must be a relationship in your model where FollowUp is linked to two different rows. 
But without the model, it's hard to help.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous 

 

The category group is not linked to another dimension.

When opening it via tabular model in Excel (the 'Analyze in Excel' button) I do not have this issue