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

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Hi Anonymous,

 

There could be a issue from your back end. Some cleaning is required at the data model side.

 

Thanks!

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Tahreem24 wrote:

Hi Anonymous,

 

There could be a issue from your back end. Some cleaning is required at the data model side.

 

Thanks!

No. The data looks fine. Unique values are correct. The model shows one value. The reason why he sees TWO values is not in the data itselft but in the relationships that creates a blank row.
However, the fact that this happens in Powerbi and NOT in analyze in excel is weird. Replicate the exact same filters that you have on powerbi in excel and see if the behaviour is the same.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Already did that, same result.

     

    Thanks for the link

    • 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?