New Hierarchy slicer should be up to available database date

[Anonymous]

HI Team,

New Hierachy slicer  showing all  month and date(2020 year showing all months and Date) I need only  availble database data

My database the data availble upto  25-March-2020.

if select 26 onwards chart showing empty please  suggest my hieracy slicer should upto 25-march-2020.

 

Thanks

Shanvitha

[v-lionel-msft]

Hi @Anonymous ,

You can add the [Date] column to the [Values] label:

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Hope you are getting it from a date calendar, Restrict your calendar till the Max date of your data

[Anonymous]

HI amit,

Thanks Your replay

My Hierach slicer should show availble year and month and date not for all dates

2020 year we have march now mean 2020 year jan,feb,march month as of now but my hierachy slicer showing all month mean jan-dec in 2020 month

I need only upto today date or my upto max date avaible date.

please check my images( i upto need 31-march-2020) mean availble min date is(01-jan-2019) to Max date is(31-march-2020) in database mean i need show 12 month in 2019 and 3 months(jan,feb,march) 2020 if data loaded tomarrow 1-Apr-2020 i need show jan,feb,march and apr 1st also in hierachy slicer

[Anonymous]

HI amit,

Thanks Your replay

My Hierach slicer should show availble year and month and date not for all dates

2020 year we have march now mean 2020 year jan,feb,march month as of now but my hierachy slicer showing all month mean jan-dec in 2020 month

I need only upto today date or my upto max date avaible date.

please check my images( i  upto need 31-march-2020) mean availble min date is(01-jan-2019) to Max date is(31-march-2020) in  database mean i need show 12 month in 2019 and 3 months(jan,feb,march) 2020 if data loaded tomarrow 1-Apr-2020 i need show jan,feb,march and apr 1st also in hierachy slicer calender.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

My test data is different from yours.

You can try the method I mentioned above.  when I tested the solution, the slicer only displays the dates contained in the date column if you do so.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Lionel Chen,

Thanks your so much its working fine.

if using custom visual its working very good.if using power BI feature slicer its not showing values filed settion(below image)

if we using Power BI feature Slicer how to fix this issue(because one of my client didnt accept custom visuals).

Thanks

Shanvitha

[Anonymous]

As with most data analysis tasks, working with time can be the most challenging detail to get correct. Power BI Pro has built-in functionality that will display a drillable hierarchy of year, quarter, month and days when a column, formatted as a date, is dropped onto a visualization. This feature can be handy in the proper visualization as illustrated in the example below.

If you are creating a table and drag a field, formatted as a date, you do not get a single date but the hierarchy as pictured below. This creates a built-in way to drill down through the year on various graphs and tables. On a visualization, this allows you to provide different views of your data over time. You can also remove a level from the list by selecting the ‘X’ next to the level depending on your needs.

[Mariusz]

Hi @Anonymous 

The below blog post has a solution for your problem.

https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn