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 visualation or table I get some values double, but when it in a slicer I don't have this issue. Even in my tabular model I do not get this issue

Anyone any idea why this can be, and how to solve it?

 

Many thanks!

 

 

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

     

15 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 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
      6 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

       

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Hi Anonymous ,

     

    You can apply report level filter on SALES VISIT column by removing blanks values.

     

    Please give Kudos and mark it as a solution if it helps you!

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