Forum Discussion

pat1214's avatar
pat1214
Frequent Visitor
7 years ago

Flat sparkline if no data exists

Hello,   I am building a dashboard which consists of different metrics. Most of them have data for past two years, except for three metrics that have data for the past 8 months only. One of the dis...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi pat1214 ,

 

Here you should create a calendar table using the formula like table = CALENDARAUTO() and create relationship between it and your fact tables. Then you can add the date column in calendar table in your visual to work on it.

 

Regards,

Frank

 
pat1214's avatar
pat1214
Frequent Visitor
7 years ago

Hello,

 

Thank you for the reply. I should have mentioned in my original post that there is a column called 'Reporting Period' in the staged table that populates the dashboard. I have attached a picture of it below as an example. 15 and 16 are metric ids. Metric 15 for example has data all the way from Oct 2016 to January 2019, but Metric 16 has data from Oct 2016 to Aug 2018. So in the sparkline visual, I am trying to get a flat line for months Sept 2018 to Jan 2019. Will inserting 'Null' for the missing values in the staged table help in achieving it? Thank you!