Forum Discussion
Only show table visual when selected a data point (=day) in line chart visual
Hi, I have a line chart with DATE (=Datum in dutch) on the x-axis to monitor the FTE/headcount in a company day by day. When I select one data point in the line chart by left clicking ( I choos...
lbendlin
Super User
Super UserYou need a couple of things to make this work
- a disconnected calendar table for the table visual
- a measure that calculates the values per each of the days based on current filters in your data model (using TREATAS, for example)
- a combination of ISFILTERED and HASONEVALUE etc to identify if you want to show the values in the table visual or not. If not, return BLANK() rather than 0.
Dear Inbendlin,
Thank you for your answer!
- There's already a dim-table date in the model with calendar fields like date, month,... or what do you mean with 'disconnected'?
- I really don't know how to proceed with your 2 last (especially the 1st one) suggestions...
Maybe I can deliver you more information?