cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bbui
Helper II
Helper II

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 @bbui ,

 

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

 

Pete

Hi @BA_Pete 

I cal BUR1R2 using USERELATIONSHIP

bbui_1-1635436055550.png

 

 

 

v-kelly-msft
Community Support
Community Support

Hi  @bbui,

 

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!

Hi Kelly,

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

v-kelly-msft
Community Support
Community Support

Hi  @bbui ,

 

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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors