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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Need help Date visualization

Hello experts there, 

I have some issues when visualize this. 

I have 1 monthly Budget table, with 3 versions: BU, R1 and R2.

For 2021 table contains only R1 & R2, no BU

bbui_0-1635425178339.png

For 2021, I only have R1 and R2, it visual correctly when i filter verion

bbui_1-1635425353421.png

bbui_2-1635425380378.png

I have problem with 2022. 

For 2022, table only contains BU, no R1 or R2 yet. 

bbui_3-1635425419409.png

I cant understand this. Do you have any idea? how can i display 2022 BU in this case? 

 

thanks for you advises 

5 REPLIES 5
BA_Pete
Super User
Super User

Hi @Anonymous ,

 

Can you share the calculation that is populating your [BUR1R2] column please?

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Anonymous
Not applicable

Hi @BA_Pete 

I cal BUR1R2 using USERELATIONSHIP

bbui_1-1635436055550.png

 

 

 

Hi  @Anonymous,

 

Which key column do you use to connect table "BUDR1R2" and Calendar?

 

Best Regards,
Kelly

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

Anonymous
Not applicable

Hi Kelly,

it is Date column & date.month YYYY-DD, both date format. 

Hi  @Anonymous ,

 

Can you create a simple sample for test?

 

Best Regards,
Kelly

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors