Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone,
In excel, I selected pivot table -> from power bi then was able to connect excel with the power bi dataset.
I'm thinking of creating a pivot table to show how many applications come from each marketing channel (ie. email, website, store) on each day. However, when I was trying to drag Total number of pplications from pivot table field to 'Values', an error message popped up
Can anyone let me know what has gone wrong please? if the worksheet is in excel, I don't have an issue. It's my first time getting data from power bi in excel so I got a bit confused.
Thank you!
Hi @kathyyy19
You need to create a measure to be used in the pivot table, you cannot use a field into the totals.
Here is how to create a measure Tutorial: Create your own measures in Power BI Desktop - Power BI | Microsoft Learn