Date slicer does not filter histogram

Question

Hi all,&nbsp;I am new to power BI and I am trying to use a date slicer to filter an histogram.I tried&nbsp;to use today's date in the date slicer in order to filter data on the last 3 months.In the histogram I want to have the number of sales on the last 3 months distincly, for that I put the sales date on the axis.However the date slicer is not working on the histogram, which is supposed to be filtered.My number of sales measure is as follow :Nb actés = calculate (sum(Lots[Nombre_lots_actés]))&nbsp;Do I need to change the formula?&nbsp;Thank you in advance for your help!

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;I have tested on my side as below picture, but not reproduce the same issue as you said. You may try to check your data type. If it is not your case, It’s better to share more about your data sample.Regards,Cherie&nbsp;&nbsp;

anonymous · Answer

Hi v-cherch-msft,&nbsp;Thank you for your answer, I realised I didn't have the same date column on my slicer and histogram, so now it is working for one measure.&nbsp;In fact I would like to have on the same histogram the number of items sold and the number of items unsold for the last 3 months. If I use the sale's date I obviously&nbsp;can't see&nbsp;the number of items unsold, is there a way to do that?&nbsp;&nbsp;Thank you&nbsp;&nbsp;

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;You may try to create a calendar to link the date in your table.&nbsp;If it is not your case, please share some data sample and expected output.&nbsp;Regards,Cherie

anonymous · Answer

Hi v-cherch-msft,&nbsp;I have a calendar table linked to a column date in my item table. This column date&nbsp;returns, depending on the&nbsp;item's status,&nbsp;the sale's date&nbsp;if the item is sold or the date when the item was delivered to the store if it's unsold.&nbsp;However, if the item unsold was delivered in january for example, it's not counted on the histogram because&nbsp;its date is not among the last 3 months...I would like&nbsp;to see this item unsold on my histogram for the month of may, june and july, is there a way to do that?&nbsp;Here is an example of data and what I expect :&nbsp;Thank you in advance for your help!

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;You may try to create a measure as requested. For example:Unsold =
COUNTROWS ( FILTER ( Table1, Table1[Status] = "Unsold" ) )Regards,Cherie

Forum Discussion

Date slicer does not filter histogram

7 Replies

Related content

Slicer for filtering several columns

Time Filter Slicer

Histogram in Power BI

Filter data using slicer

Slicer Filtering Another slicer