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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
bsas
Post Patron
Post Patron

How to build sankey chart using monthly snapshoots

 Hi all,

 

I'm trying to build sankey based on monthly snapshoots in selected period, where start date is min snapshoot date in period and end date is max snapshoot date in period. We should ignore all other snapshoots within the period. 

 

example of my table

 

IDdatestage
1111/31/20182
1112/28/2018(ignore it)
1113/31/20183
2222/28/20182
2223/31/2018(ignore it)
2224/30/2018(ignore it)
2225/31/20184


same table if we change period 

 

IDdatestage
1111/31/20182
1112/28/20183 (ignore it)
1113/31/20183
2222/28/20182
2223/31/20183

 

Will appreciate any help with this.

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@bsas,

 

You may try adding a measure and drag it to Visual level filters.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks @v-chuncz-msft,

 

In my case I need to create calculate column which will ged value from min date in selected period (same for max) and set it for all record in appropriate ID (e.g. in case I have 4 raws with same ID and 4 dates column should get value from date raw which <= min date in period. Same approach for Max. I need this min and max as calculated column because will use it as source and destination in sankey chart.

 

IDdatestageminalternative minmaxalternative max period 1/20/2018 - 5/2/2018
11111/31/201822244  
11112/28/201832 4   
11113/31/201832 4   
11114/30/201842244  
         
         
IDdatestageminalternative minmaxalternative max period 2/10/2018 - 4/24/2018
11112/28/201832233  
11113/31/201832233  

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.