Forum Discussion
Need help with stacked bar chart visual
- 3 years ago
jdbuchanan71 I was able to make this work by creating multiple measures and then plotting them on the bar chart. Thanks for all your help!
First, a couple notes on your [Count of Users] measure.
You want to avoid applying a FILTER on an entire table. It causes poor performance in the model and is not necessary.
Also, this line in your filter.
MEETINGS_ADOPTION[MEETING_DATE] <= MIN ( 'Calendar'[Date] ) &&
MEETINGS_ADOPTION[MEETING_DATE] >= MAX ( 'Calendar'[Date] )
Would only ever return a record if you had your Calendar table filtered to a single day.
Lets say you pick 6/1/2023 - 6/30/2023 on your Calendar table.
A meeting with a [MEETING_DATE] of 6/15/2023 would not match either criteria of that filter line
So we end up with a corrected measure like this.
Count of users =
CALCULATE (
DISTINCTCOUNT ( MEETINGS_ADOPTION[USER_ID] ),
MEETINGS_ADOPTION[MEETING_DATE] >= MIN ( 'Calendar'[Date] ) &&
MEETINGS_ADOPTION[MEETING_DATE] <= MAX ( 'Calendar'[Date] )
)
Now, in the Status calculated column on your MEETINGS_ADOPTION, do any of the rows get tagged with "Has not had a 1on1"?
It seems like your measure should be working if there are any rows in the MEETINGS_ADOPTION with "Has not had a 1on1".
Could you maybe share your .pbix file (post it to drop box and share the link here)?