Forum Discussion

Aspi's avatar
Aspi
Helper I
5 years ago
Solved

Visualization in Dashboard

Hello all you BI Gurus, wanted to ask if anyone knows how to create a visualization (or if one already exists) that will use values from two existing visualization and provide a result. See attached ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Aspi ,

     

    According to your description, the values displayed in the Card visuals are obtained by applying some filters not measures ,so you could not get the divide value directly,right?

     

    And based on the screenshots you provided ,let us ignore the date and region filter,just focus on Issue Category:

    AWB Count with Errors  is composed of data with the value<>(Blank) in Issue Category column,
    Total AWBs Processed is the total rows.
     
    I suggest you create some measures to do it.
    AWB Count with Errors = COUNTX(FILTER('Table','Table'[Issue Category]<>"(Blank)"),[Issue Category])

    Total AWBs Processed = COUNTROWS('Table')

    Error Rate = DIVIDE([AWB Count with Errors],[Total AWBs Processed])
     

    The final output is shown below:

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Aspi ,

 

According to your description, the values displayed in the Card visuals are obtained by applying some filters not measures ,so you could not get the divide value directly,right?

 

And based on the screenshots you provided ,let us ignore the date and region filter,just focus on Issue Category:

AWB Count with Errors  is composed of data with the value<>(Blank) in Issue Category column,
Total AWBs Processed is the total rows.
 
I suggest you create some measures to do it.
AWB Count with Errors = COUNTX(FILTER('Table','Table'[Issue Category]<>"(Blank)"),[Issue Category])

Total AWBs Processed = COUNTROWS('Table')

Error Rate = DIVIDE([AWB Count with Errors],[Total AWBs Processed])
 

The final output is shown below:

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

Aspi's avatar
Aspi
Helper I
5 years ago

Hi Eyelyn,

Thank you for your help and providing the solution. It has worked well.

Can I ask you another question in relation to the same dashboard please. Can you advise how do I make the dashboard display 'Blanks' as 'No errors' i.e. I need the above Pie Graph showing 'No Errors' in place of '(Blank)' (the Purple 60% of the Pie).

Do advise your thoughts.

Best Regards.