Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
Is there a way to create a table with text values via analyze power bi in excel.
Analyze in excel gives tables to make pivot tables and there is no option to get text values in values.
I can not make any measures as well.
Solved! Go to Solution.
Hi @Anonymous ,
Please refer the contents in the following documentation to create the measures, then applied them onto Values area.
Can't drag anything to the PivotTable Values area (no measures)
Best Regards
Rena
Hi @Anonymous ,
Please refer the contents in the following documentation to create the measures, then applied them onto Values area.
Can't drag anything to the PivotTable Values area (no measures)
Best Regards
Rena
@Anonymous , check this feature of May 2020, can help you
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_Excel
You have to do all your data type conversions in Power BI. "Analyze in Excel" can only consume, it cannot modify anything, Same with the measures - you need to explicitly declare measures in Power BI even if you don't need them (for simple summation for example).
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |