Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help!

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_Comple...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
amitchandak
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak, yes Business_Process_type is coming from the same table.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

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

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

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