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.
Hi
I have a table which contains entries in the format:
ExtractDate,UserCount,Mail
When trying to display data in graphs etc. using PowerBi I Desktop want to display the latest entry for "UserCount" (instead it keeps trying to sum the values). How can I do this?
Thanks in advance
Solved! Go to Solution.
@Anonymous Please add a "Visual Level Filter" as below
Proud to be a PBI Community Champion
@Anonymous Yes, it will do. As the default behaviour of numeric fields in Power BI is to do Sum. Sample data and expected output will be helpful to suggest you an accurate solution.
Proud to be a PBI Community Champion
Hi
So screenshots should be below. Basically for each update to a sheet we want to take the latest values. So want to show how many people have mail out of those in the "OnPremADCount" (e.g. 500/45590)
@Anonymous Please add a "Visual Level Filter" as below
Proud to be a PBI Community Champion
Perfect, thanks!
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 | |
81 | |
67 | |
61 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |