The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Im trying to create a like/dislike button that when clicked would write back into excel and add either like or dislike into a cell. Does anyone know how to do that?
That is a great idea but what if there was no data in the liked portion of the table, how would I get it so that likes would get added to the table
Hi @SamFW12
Power BI currently doesn't have a writeback capability. You can try using PowerApps or PowerAutomate or a combination of both.
Proud to be a Super User!
That's a good idea, the only issue I have with power apps and power automate is that I cant seem to figure out how to get the likes/dislikes to appear on a certain cell without creating a new row
First, you need to create two measures in Power BI to track the number of likes and dislikes. These measures will act as counters.
LikesCount = COUNTROWS(FILTER('YourTable', 'YourTable'[Liked] = "Like"))
DislikesCount = COUNTROWS(FILTER('YourTable', 'YourTable'[Liked] = "Dislike"))
Replace with your Table.
User | Count |
---|---|
140 | |
121 | |
108 | |
51 | |
46 |
User | Count |
---|---|
217 | |
98 | |
94 | |
89 | |
88 |