Double text value in visuals

[Anonymous]

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!

[Anonymous · Accepted solution]

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]

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]

Hi @Tahreem24 

This does not work...

[Tahreem24]

Hi @Anonymous,

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

Thanks!

[Anonymous]

---

@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]

Already did that, same result.

Thanks for the link

[Anonymous]

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]

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?

[Anonymous]

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]

Yes that is the case

Thanks everyone for your help. I'll update this thread with any updated.

[Anonymous]

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]

I can't share the data model too bad.

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

[Anonymous]

I suggest this read, might help

https://www.sqlbi.com/articles/blank-row-in-dax/

[Anonymous]

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]

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