Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I want to show who selected which fruits and how many time they selected it. Not shown is another column for dates.
Solved! Go to Solution.
Hi,
In the Query Editor, right click on the Fruits column and select Split Column > By delimiter. Specify the delimiter as comma and space. Expand Advanced and select Rows. Click on OK. Click on Close and Apply.
Hope this helps.
Thanks for the reply from lbendlin and Ashish_Mathur.
Hi @New_Folder ,
I'll add to Ashish_Mathur 's answer to the effect you intended.
1.As shown in the figure, you can click on the corresponding option to split the commaed ones into a separate line.
2.Create two visual objects, the pie chart and the slicer, using user as the field for the slicer.
3.The final result is as follows:
Best Regards,
Zhu
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi,
In the Query Editor, right click on the Fruits column and select Split Column > By delimiter. Specify the delimiter as comma and space. Expand Advanced and select Rows. Click on OK. Click on Close and Apply.
Hope this helps.
You need to put in more work. Your data model needs a User reference table, a Fruits reference table, and a measure that calculates the desired value. Put all three in a matrix visual to show the entire solution graphically without the need for slicers.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
72 | |
62 | |
51 | |
48 |
User | Count |
---|---|
206 | |
90 | |
61 | |
59 | |
57 |