Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I am trying to use multiple measure on the same axis. The photo below was done in Tableau. How do I create the same in PowerBI
Solved! Go to Solution.
@Anonymous ,
please refer this below thread which I have solved earlier,
https://community.powerbi.com/t5/Desktop/Create-table-from-measure-for-visual/m-p/2501880#M889608
Thanks,
Arul
Hi, @Anonymous
As meationed by @Arul ,you can manually enter a column containing the names of all measure fields.
Then use function ‘IF’ to create a field that summarizes the results returned by each measure.
Measrue_value =
SWITCH (
MAX ( 'Table'[MeasureName] ),
"Measure1", [Measure1],
"Measure2", [Measure2],
"Measure3", [Measure3]
)
Best Regards,
Community Support Team _ Eason
@Anonymous ,
please refer this below thread which I have solved earlier,
https://community.powerbi.com/t5/Desktop/Create-table-from-measure-for-visual/m-p/2501880#M889608
Thanks,
Arul
| User | Count |
|---|---|
| 57 | |
| 43 | |
| 32 | |
| 16 | |
| 13 |
| User | Count |
|---|---|
| 84 | |
| 70 | |
| 37 | |
| 27 | |
| 24 |