cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SV1980
New Member

Stacked Column Chart - Only Display relevant Data

Hi, 

 

I have a stacked column chart and a date slicer. 

 

When I select a date range, I want my x-axis to only display the data (in this case employee names) for that date range. 

 

In this case it is employee time booked. If I select September 2022 - I only want my x-axis to display employees who booked time for September 2022 and not employees who did not book time. 

 

Please help 🙂 I am a complete novice to building PowerBI reports.

1 REPLY 1
amitchandak
Super User
Super User

@SV1980 , In the your date table is joined with book date, it will filter it.

 

else you have to create a measure like

 

new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Book Date] >=_min && 'Table'[Book Date] <=_max))

 

here book date is only having date value

new column , if needed

Book Date = datevalue([Book Datetime])

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors