Forum Discussion
PowerBuddy1
4 years agoFrequent Visitor
Time Intelligence Visual
Hi, I am trying to display YTD LY, MTD, and Current Year YTD in the same visual (client requirement). Something like below: Measures: YTD_Yield= if([Total_Yield] =BLANK(), B...
danextian
4 years agoSuper User
Hi PowerBuddy1 ,
This is possible but very finnicky. You'll have to create another dimension table with rows for YTD and months so it can hold the said values. You can use my sample pbix to help you get started. https://drive.google.com/file/d/1bbdDlwd1xAe0F37iYWHEik7s33l1vcxc/view?usp=sharing
Below is a sample Column and Line Viz
PowerBuddy1
4 years agoFrequent Visitor
Hi danextian This is exactly what I am looking for! But not able to access the file. It says access denied. Have requested for access. Can you pls provide? Thank you so much!
- danextian4 years agoSuper User
Hello. I've made the pbix publicly available.
- PowerBuddy14 years agoFrequent Visitor
Thank you so much!