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 choose one day ), then I want to show a detail table under the line chart . When I select nothing in the line chart, then I do no want the table visual swowing any data.
Case when nothing is selected:
Case when something is selected (12/01/2023):
I've tried the next measure but I got this error message: arithmetic operation resulted in an overflow. So when a date (=datum) is selected, the value of the measure returns = 1. When I add this to the visual level filter from the table visual and select value = 1, then it normally has to work but unfortunately I got this error message.
Who can help me with this issue?
Thx!
2 Replies
- lbendlin
Super User
You 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?
