Forum Discussion

amangathania's avatar
amangathania
Advocate I
8 years ago

Time intelligence does not work

Hi Team, wanted a help in power BI viusalisation.. i have been stuck on something from last two weeks and it's impacting how leadership team view our dataset.   Cut-short, I want my graphs to read...
Need Help
amangathania's avatar
amangathania
Advocate I
8 years ago

Let me explain that over again:

 

Currently i have x axis as: 2016 Q2, 2016 Q3, and so on till 2018 Q3..i want that to be JQ16, SQ16, DQ16. However, when i do that i am not able to drill down further more than 1 step and also not able to see "SEE RECORDS" option.

 

That's because JQ16, SQ16, DQ16 and so on... disables the natural querry for timeline intelligence.

 

I need a quick fix.. fix that could keep my time intelligence running and enabling a user to drill down the data from YEAR to QUARTER to MONTHS and DAYS and also "SEE RECORDS" option.

 

Looking for a response.

 

Thanks!

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi amangathania,

 

If you want enable drill down between your custom columns, from YEAR to QUARTER to MONTHS and DAYS, you can create custom category hierarchy.

 

Timeline intelligence only works for date/time, your custom column JQ16, SQ16, DQ16 is formated as Text. So, you cann't use timeline intelligence based on this column.

 

Please check whether you hit the limitations to "See Records".

 

Regards,

Yuliana Gu