Only show table visual when selected a data point (=day) in line chart visual

[UmYil]

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! 

[lbendlin]

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.

[UmYil]

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?