Forum Discussion

Rahul_Bhatt's avatar
Rahul_Bhatt
Advocate I
10 years ago

Average Per Cover Depends for Dynamic Time Period

My query is  related to Restaurant Point of view, we are looking for a solution which gives me  “Average Per cover straight line” should come on graph  depends on time period like if  we look it  for...
Need Help
Rahul_Bhatt's avatar
Rahul_Bhatt
Advocate I
10 years ago

Eric_Zhang  i am still facing the issue Please find the data model  and test it on the secnario where for some years data starts 8 and like that .please download the test data.PIBX from below link.

 

https://we.tl/0tRRy4OtdT

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

Rahul_Bhatt

 

The peak&valley and caused by the absent months. I've created a calender table to fill up the missing months, please check the attachment. By the way, I was testing on the latest May's release, please upgrade your Power Bi desktop if you can't open the pbix.



Please accept it as solution if the the attaced pbix works, thanks. :) If you have any question, feel free to let me know.

  • Rahul_Bhatt's avatar
    Rahul_Bhatt
    Advocate I
    10 years ago

    HI Eric_Zhang this solution doest not work in case when we select a specific year, its giving me solution in case of all the year selected but what if i use slicer and select the year from that , in that its not working.