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.
Is there a way to show this graph without showing 2 of the columns and the nunbers staying the same? I am having trouble showing this data for the High fields without showing the mid and low. Is there anyway to hide the low and mid columsn and just show the high without the numbers distoting, I cannot seem to do this with the fitlers at all.
Solved! Go to Solution.
Hi, try using this measure
Share = DIVIDE ( SUM ( Table4[Value] ); CALCULATE ( SUM ( Table4[Value] ); ALL ( Table4[Type] ) ) )
Regards
Victor
Hi, try using this measure
Share = DIVIDE ( SUM ( Table4[Value] ); CALCULATE ( SUM ( Table4[Value] ); ALL ( Table4[Type] ) ) )
Regards
Victor
Hi @Vvelarde
OK this looks amazing but I haven't done ameasure like this before in the code it says Table4{value] Wht would I need to replace these with in my instance? Sorry haven't done this before.
Also its stating there might be an issue also wiht the code as it said there was an issue?
@Vvelarde This is working! Thanks so much.
OK one more little question, see if you can help with this. Is there a way to get this to display as a % rather than as a decimal at all?
Thanks so much
Select the measure in Fields Panel and go to Data Type -Format Select Percentage and number of decimals.
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |