Help!

[Anonymous]

Greetings,

I am building a dashboard, where I need to show Business_Process_Type against the Diff_Completed_Initiated and need to apply filter- 1. ESS_MSS_Adoption_Category = MSS & 2. Diff_Completed_Initiated is greater than 7. But in the visualization When I am taking Diff_Completed_Initiated in the value field, its shwoing like below - 

and its wrong.. 

Input -

Could someone suggest On this?

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

When you set the filter with the condition Diff_Completed_Initiated is greater than 7, what the visual filter finally is that the aggregation value of Diff_Completed_Initiated is greater than 7. For example, if you have the following two records, it can be displayed eventually, because 5+3>7...

Business_Process_Type	ESS_MSS_Adoption_Category	Diff_Completed_Initiated
Edit Position	MSS	5
Edit Position	MSS	3

Please also drag the field Diff_Completed_Initiated to Legend fields and toggle off Legend option in Format pane.

Best Regards

[amitchandak]

@Anonymous , check the aggregation of Diff_Completed_Initiated?  Also, is Business_Process coming from the same table or a different table?

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

[Anonymous]

Hello @amitchandak, Can you guide me how to attach pbix file?

[amitchandak]

@Anonymous , You can upload to dropbox or onedrive and share the link. Also, share expected output

[Anonymous]

@amitchandak, yes Business_Process_type is coming from the same table.

[Anonymous]

@amitchandak , Unfortunately my work place does not allow file sharing using one drive or Dropbox etc .