The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone
I used Word Cloud visual to show the top 5 trending keywords and would like to use Card visual to show the description of each keyword when clicked.
When nothing is selected from Word Cloud, I want the cards visual to be blank by default. However, I'm having a hard time fixing this since the only options I have for Card Visual is First, Last, Count and Count (Distinct). In my case, card visual automatically shows the first keyword in the database (which is not included in the Top results in Word Cloud).
Tried to use conditional formatting but it's not applicable since all values are text values, no numerical values. Would really appreciate if you have other easier alternatives to present the description aside from the card visual.
Thank you so much!
Solved! Go to Solution.
Hi @powerbirookiee ,
After testing, similar functionality can be achieved in the normal card visual with the SELECTEDVALUE function. However, Word Cloud visual does not support it for the time being.
in Word Cloud, no reflection.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @powerbirookiee ,
After testing, similar functionality can be achieved in the normal card visual with the SELECTEDVALUE function. However, Word Cloud visual does not support it for the time being.
in Word Cloud, no reflection.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @powerbirookiee,
Instead of just using a column/field in a visual and choose from the limited options to show which value to show, try using a measure instead.
Example
Selected Item =
SELECTEDVALUE ( Data[Item], "" )
//to show a blank white space if no single value is selected or the filter context doesn't return a single Data[Item] value
User | Count |
---|---|
78 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |