Forum Discussion
A problem of interaction
Hello community,
I need your help
I have two table one is user the other is date
I have two relationships one is active between date_contract_end and actual_date(date table)
and inactive relationship date_contract_start and actual_date(date table)
I create a clustred column chart and a table to know the name of new and exit users
for the clustred column chart I select count(user_id) for the exit entry number and create a measure calculate(count(user_id),userelationship( date_contract_start,actual_date(date table)))
The problem is when selecting the exit entry column it shows me the name of users but when selecting the new entry number it shows me the same name of exit entry
here is some screenshots to clear more the situation
When selecting the exit number it shows me correctly the names:
But when selecting the new entry it shows me the name of exit entry, there is no interaction
Thanks in advance
Hi Anonymous ,
What I did was to create an unrelated table with the values start and end then created the following measure:
Chart Values = SWITCH ( TRUE (); SELECTEDVALUE ( 'Measure_Selection'[Measure] ) = "Start"; [Entry]; SELECTEDVALUE ( 'Measure_Selection'[Measure] ) = "End"; CALCULATE ( DISTINCTCOUNT ( USERS[user_id] ); FILTER ( USERS; USERS[date_fin_ctrt] <> BLANK () ) ); DISTINCTCOUNT ( USERS[user_id] ) )Now just make your chart with following strucure:
- Axis - Calendar[Month]
- Legend: Measure_Selection[Measure]
- Column Values: [Chart Values]
Then add the [Cart Values] to the table visualization and hide it.
Check PBIX file attach.
2 Replies
- MFelix
Super User
Hi Anonymous ,
What I did was to create an unrelated table with the values start and end then created the following measure:
Chart Values = SWITCH ( TRUE (); SELECTEDVALUE ( 'Measure_Selection'[Measure] ) = "Start"; [Entry]; SELECTEDVALUE ( 'Measure_Selection'[Measure] ) = "End"; CALCULATE ( DISTINCTCOUNT ( USERS[user_id] ); FILTER ( USERS; USERS[date_fin_ctrt] <> BLANK () ) ); DISTINCTCOUNT ( USERS[user_id] ) )Now just make your chart with following strucure:
- Axis - Calendar[Month]
- Legend: Measure_Selection[Measure]
- Column Values: [Chart Values]
Then add the [Cart Values] to the table visualization and hide it.
Check PBIX file attach.
- AnonymousNot applicable
Thank you so much 🙂