Forum Discussion
Word cloud inconsistent values
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.
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.
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.