Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In PowerBI I'd like to build Non-standard matrix very similar to the report in Google Analytics.
I want to change my subtotal to measure, which is calculated as the difference in percentage of the two values
If it's possible, help me please)
No, it's not possible. Currently, it's not supported to custom the subtotal into measure. Even you can change the subtotal, it still can't calculate the difference between two entries. Because the measure must aggregate all entries under the row group, if there's more than two entries, the measure can't determine which two entries should be picked up for calculation.
Regards,
@v-sihou-msft, thanks for you answer.
Maybe it possible without "SubTotals"? For example, add a measure or column to the table.
Is there any possibility of presenting data in this form (as in GA)?
Does anyone know how to do this?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |