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.
Hello,
Please help me with your suggestion to fix my issues, As per the earliers questions posted , I not able to use measure in Visual axis.
I have already tried below methods.
1. Try to create separate calculated table- direct Query mode not supporting to create calculated table.
2. Tried creating calcialted column using measure- Not supported by direct query mode.
I have created measure wch contains the growth values and salary details. I have to create one visual to display range like (0%,5%,10%..) .and salary in Y axis .
Please suggest me on the possibilities to cover the requirement.
Probably not going to be able to get there with Direct Query mode. Generally, this requires the "disconnected table trick" which you probably can't create because of Direct Query. The disconnected table goes in the axis. And then a measure for each item in the axis along with a final measure (the one you put in the Values) with a HASONEFILTER and SWITCH statement.
Thanks for the Suggestion. Absoultely your right.
HASON doesnt support in direct query mode.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |