Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
141 | |
70 | |
69 | |
52 | |
52 |
User | Count |
---|---|
209 | |
92 | |
64 | |
60 | |
57 |