How to get WordCloud Blank under certain condition?

[maqsud]

I have survey data. I had made the WordCloud from comment responses from the Survey. 

Following is the table: 

'data'

EmpID	Location	Function	Tenure	Gender	Comment
1	Chennai	Corporate	1-2 years	Female	Too informal at home
2	Delhi	Agency	0-1 years	Male	To informal at home
3	Mumbai	Corporate	2-5 years	Male	Overcoming the urge to take nap.
....	...	....	...	...	..
101	Mumbai	Logistics	1-2 years	Male	Work from Home not possible

Following is the measure of No. of Response card = COUNTROWS(data)

Below is the snap of my WordCloud Dashboard:

Following is the representation after drilling down to less than 5 No of Response :

Expected Outcome: I want WordCloud to be Blank or throw some error after getting No of Response less than 5 as in the above case.

Your help is highly appreciated. Thank you!

[amitchandak]

@maqsud , The way I can think of is switch visual based on Count Value, see if bookmark can help

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[maqsud]

@amitchandak, The Above article, is for using Button and Bookmark. And I am looking for Visual Level Filter or some measure

[amitchandak]

Create two-measure one with Text and one you measure. Check the value of your measure a display value of another measure. But Only thing it will give data type issue 

Change the measure without slicer based on value

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

[maqsud]

@amitchandak, I have added two measure as follows into WordCloud. But still getting Blank WordCloud. 

Text Measure into values of WordCloud

TextMeasure = CONCATENATEX(data,data[Comment Columns]," ")

No of Response measure into Visual Filter of WordCloud by 

TotalResponse = COUNTROWS(data)

Thank you!

[AllisonKennedy]

@maqsud  Add the No of Response measure as a filter to the word cloud visual, set that to show items when value is greater than 5.

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv

[maqsud]

@AllisonKennedy I added No of Response measure as a filter to the word cloud visual with show items when the value is greater than 5.

But I am not getting any words even after having No of Response greater than 5.

[AllisonKennedy · Accepted solution]

@maqsud 

This is relatively simple fix. Set your word cloud up again so that it is behaving as you want without the filters, so putting Comments back in the Category and count comments in the value.

The reason the filter shows an empty word cloud is because TotalResponse is a measure that changes based on the Word Cloud comments, so in the context of the Word Cloud, TotalResponse is always 1 (which is ALWAYS less than or equal to 5) and therefore your Word Cloud is always blank. 

Try updating your TotalResponse measure to look like something like this: 

TotalResponse= CALCULATE(COUNTROWS('data'), ALL('data'[Comment Columns]))

Then, as we discussed before, add the TotalResponse as a filter to the Word Cloud visual for TotalResponse >5. 

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv