Stacked column and line chart view showing unselected users on the X axis

[newpi]

Hi,

I have an average of average formula which correctly calculates average between  groups or users. My problem is when I use this formula and select only 2 or few users out of 9, it is showing value bars for those selected users but it is showing all other UNSELECTED USERS as well on the 'X' axis with blank values. I want to just show the selected users on my X axis and their corresponding avg line .

My formula is 

Avg Hours / Day (Team)  =

CALCULATE(AVERAGEX(VALUES('Table Name'[User Name]),[Avg Hours / Day]) ,ALLNOBLANKROW('Table Name'[User Name])) 

or
Avg Hours / Day (Team) = 

AVERAGEX(SUMMARIZE('Table Name','Table Name'[User Name],"_1", [Avg Hours / Day]),[_1])

Only user name is a column value in the above formulaes and avg hours/day is a DAX measure

Both the formulas work in calculating the average of average correctly but I do not want unselected users to appear on my axis. 

Below is a screenshot of how it looks. I have a group selected in my slicer on the top. Would greatly appreciate a solve for this.

[Ashish_Mathur]

Hi,

Does this measure work?

=IF(ISBLANK([Avg Hours / Day (Team)]),BLANK(),[Avg Hours / Day (Team)])

If it does not, then share the link from where i can download your PBI file.

[newpi]

@Ashish_Mathur The measure is not working. Its still selecting all unselected users. I'm not sure if I Can share the PBIX file since its company data, any other way to do this?

[v-easonf-msft · Accepted solution]

Hi , @newpi 

You can take a try to create a visual control measure.

Something as below:

Country visual control = IF([Avg **** Hours / Day]=0,0,1) 

Then drag this measure to visual filter pane as below,then apply it

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[newpi]

@v-easonf-msft Thanks. This was really helpful. Was struggling with this since a week. It worked perfectly in combination with other's solution here. @pranit828 

[pranit828]

Hi @newpi 

It has to do with how the interactions is configured.

Goto format --> Interactions

Click on user selection pane.

On top of the chart, which you need filtered , you will see the below icons popup.

Select the one which is highlighted above.

Did I resolve your issue? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!

Regards,
Pranit

[newpi]

@pranit828 I can't see the icon in the middle when I try to edit interaction. I only the the first and 3rd icon . Attached img