Forum Discussion
Filter Visual question
Good morning Gang, i have a question about modifying the look of a filter
i have a filter for Shift time, but i would like to add the count of events to the filter view with the filter category
Would like the shift filter to have the count with the text rather than having to add a seperate text visual with measure and try to match it up
would love to have something like Day (26k) / Evening (3075) / Night (2473)
thanks in advance
One possible strategy would be to create a calculated column in your Details table that calculates the distinct count per shift and then concatenates that with the shift type. Then you would use your calculated column as the slicer.
A basic example would look like...Hope this gets you going in the right direction.
4 Replies
One possible strategy would be to create a calculated column in your Details table that calculates the distinct count per shift and then concatenates that with the shift type. Then you would use your calculated column as the slicer.
A basic example would look like...Hope this gets you going in the right direction.
works amazing, thank you so much
hello again and sorry for the bother,,, do you know if i can adjust the calculated column script so that when i use another filter, that it woudl update the counts?
example my top filter is from a field called user, if i select a specific user from the same details datasource, the counts to not update specific to that user..
is there a way to add that logic to the script?
I am not sure that this would be possible as a calculated column works within the context of the table that it is created in. It would not 'know' that a slicer has been applied.
