Slicer does not affect card.

[Anonymous]

The percentage card does not change if I select the PURPOSE slicer. It only change when I select the YEAR. YEAR and PURPOSE are from the same table (table A). The percentage card is from different table (table B) but already connected in Model View. I checked on 'Edit Interactions' button, everything is connected also. What should I do to make the percentage change when I select PURPOSE?

[v-yangliu-msft]

Hi  @Anonymous ,

1. Save and place the formed PBIX file where you can see it

2. Then copy the PBIX file to OneDrive

3. Select the PBIX file you need, click the vertical ellipsis, select your Copy Link, and copy this link

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yangliu-msft]

Hi  @Anonymous  ,

You can check whether it is related to the following

1. DAX function
2. Filtering direction between tables
3. Relationship between tables

If you can, you can upload the pbix file to onedrive, copy and link to this post, so that we can help you

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

https://isiswauitmedu-my.sharepoint.com/:u:/g/personal/2016307227_isiswa_uitm_edu_my/Eex13mdeNsVOpNJ...

@amitchandak @v-yangliu-msft @ryan_mayu Is this the link? Pleae help me

[Anonymous]

@amitchandak @ryan_mayu 

https://app.powerbi.com/view?r=eyJrIjoiODA5MWJkOGMtNmNkMC00YzAxLTgwZTYtZGMzODgxMjY2MjU2IiwidCI6ImNkY...

https://app.powerbi.com/groups/me/reports/3fd2fdad-a1d4-4212-86d0-75c71b3b7aca/ReportSection

Here you go. I'm not sure which link you need.

[ryan_mayu]

@Anonymous 

we need to review your pbix file, not the publised report. We can't find the root cause by viewing the report.

[amitchandak]

@Anonymous , How is you % using all or all selected that need to be checked. Other can inactive relation

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[ryan_mayu]

@Anonymous 

could you please provide your pbix file?