Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Word cloud inconsistent values

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 d...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.