Word cloud inconsistent values

[Anonymous]

Hi 

I have a strange problem with the word cloud visual:

Two word clouds, both reference to the same field (sales article titles). Both have exact the same settings. Only difference: one shows data for 1 month, example December 2020. The other references to total date hirstory, example October - December 2020.

The problem is that the first word cloud, which only references to one month, calculates more repetitions for the same word than the second word cloud, which reflects the total date history. This should at least be vice-versa.

This is for every word the same case. Example the "word" 1 is repeated 672 times in December 2020 and repeated 472 times from October - December 2020 - as per word cloud...

This should of course not be the case. Can someone help with this?

[v-rzhou-msft]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[amitchandak]

@Anonymous , Can share the setting(Filter) or measure/ formula you are using

I am assuming you have measure like this for one month

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

Or may be the visual level filter

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak hi and thank you. Filters:

- Word cloud 1: DATE is; December

- Word cloud 2: DATE is; none selected (all dates)

There are no other filters set. I have no measures calculated either.

Unfortunately I can't share sample data or pbix. I've checked both word clouds step by step several times. Only difference is the date filter. Everything else is the same for both word clouds.

What may be important; both visuals have the known "too many values" message. 

Technically I don't know if word cloud 1 calculates it's repetitions from different rows from the same column - this could explain the difference.

[v-rzhou-msft]

Hi @Anonymous 

I think your problem is that the word visual(no filter) should return a result bigger than 672 (Dec), returns a incorrect value 472.

Here I have some advice:

1. Please check whether your power bi desktop version is the latest one.

If it's not, please update your desktop from this link: Download

2. You may use count function in word cloud without building a measure.

Check the function in both visuals you use is count function instead of discount function.

I have a test by my sample.

Result:

Left one Word D in Dec return to 2, Right one Word D no filter return to 5.

Please check whether there are other filters in your Word2.

Error: Too many visuals may be caused too many word categorys in your (sales article titles).

You can show TopN to solve this issue.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.