Forum Discussion

pstanek's avatar
pstanek
Icon for Post Patron rankPost Patron
9 years ago

Date - too slow calculation

Hi, I have column with date format,  because of that reports are too slow.   I created two slicers from that column, but  It has to calculate it from milions rows, that delays report calculation.
Need Help
Show and Tell
pstanek's avatar
pstanek
Icon for Post Patron rankPost Patron
9 years ago

I  only create report in power Bi for others, so I use no additional slicer in Query Editor. Problem is that calculated column

Year=YEAR('Table'[Date]) ,Month=MONTH('Table'[Date])  are too slow ,when I have Slicers Year, Month. 

It calculates so long only to say we have months 1-12. It should se useful to have calendar in power bi.

pstanek's avatar
pstanek
Icon for Post Patron rankPost Patron
8 years ago

Is there custom visual - calendar slicer, that does not need to be feed by data?

 

Example  when you use sql  you can set up time interval without using data. It uses data only after slicer is set up. not to calculate him.

 

It is useless to wait long time only to know we have 12 months   by calculating Month(date). I can declare month immediately

  • pstanek's avatar
    pstanek
    Icon for Post Patron rankPost Patron
    8 years ago

    I have an idea, but I do not know if it is possible. I would like to know  declare  order calculation of visuals.

     

    For example  I would like to let slicers to be calculated first and other visuals after that. Not other visuals calculated before setting up slicers