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 all,
I am very new to PowerBI and am searching for your help on the below issue.
The below visual is dragged from 5tables (2018 - 2022), I filter by name of person. With some people, they do not have the data in 2018 or 2019 or 2020... - However the visual keeps shows global data rather than blank.
How can I sort it out please? Thank you.
Solved! Go to Solution.
Hi, @alp_upgirl
I don't know how your tables are connected, so I've made a few examples that I hope can help you.
Sample data:
Name5 has no data in the 2018 and 2019 tables and should be blank for hours.
Measure:
2018 = CALCULATE(SUM('2018'[Value]),FILTER('2018',[Name]=SELECTEDVALUE('2018'[Name])),FILTER('Date',[Year]=SELECTEDVALUE('Date'[Year])))
2019 = CALCULATE(SUM('2019'[Value]),FILTER('2019',[Name]=SELECTEDVALUE('2019'[Name])),FILTER('Date',[Year]=SELECTEDVALUE('Date'[Year])))
2020 = CALCULATE(SUM('2020'[Value]),FILTER('2020',[Name]=SELECTEDVALUE('2020'[Name])),FILTER('Date',[Year]=SELECTEDVALUE('Date'[Year])))
Result:
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Much appreciate your help!
Hi, @alp_upgirl
I don't know how your tables are connected, so I've made a few examples that I hope can help you.
Sample data:
Name5 has no data in the 2018 and 2019 tables and should be blank for hours.
Measure:
2018 = CALCULATE(SUM('2018'[Value]),FILTER('2018',[Name]=SELECTEDVALUE('2018'[Name])),FILTER('Date',[Year]=SELECTEDVALUE('Date'[Year])))
2019 = CALCULATE(SUM('2019'[Value]),FILTER('2019',[Name]=SELECTEDVALUE('2019'[Name])),FILTER('Date',[Year]=SELECTEDVALUE('Date'[Year])))
2020 = CALCULATE(SUM('2020'[Value]),FILTER('2020',[Name]=SELECTEDVALUE('2020'[Name])),FILTER('Date',[Year]=SELECTEDVALUE('Date'[Year])))
Result:
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |