Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
KH_Mike
Helper III
Helper III

Show missing data in table

Hi All,

 

I have a dataset like below.

 

YearTypeAmount
2020A10
2020B20
2020C30
2020D40
2020E50
2021A60
2021B70
2021C80

 

Now, I create a measure to calculate the Last Year (2020) result and show it together with this year data like below.

 

Slicer = 2021

 

TypeThis YearLast Year
A6010
B7020
C8030

 

However, I would like the "Type" also contain what 2020 have but 2021 no record like below.

 

TypeThis YearLast Year
A6010
B7020
C8030
D040
E050

 

Anyone how to do it?

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

6 REPLIES 6
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

That what I need. Thank you.

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
KH_Mike
Helper III
Helper III

Hi @ALLUREAN , @PC2790 ,

 

Sorry that I tried the way you provided, still not able to do it.

PC2790
Community Champion
Community Champion

Try adding +0 in your measure formula and see if it works

ALLUREAN
Solution Sage
Solution Sage

Hi, @KH_Mike 

 

Can you try this? Right click on Type field:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data

 

 




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.