cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kparab Frequent Visitor
Frequent Visitor

I want display data in dial guage for two different ways

Hi ,

 

I have set of Operators which are segregated as if (Chats)Transferred='Y' then show Handled and Transferred as user name otherwise keep as it is the operator name - which i have implemented in User column - Image 1

By default  I am showing average of overall column of last 4 weeks in each Dial Guage visual ( Excluding handled and transferred user) i.e. Transferred='N' (Image 2) 

But on selection handled and transferred from slicer the dial guage should display average of overall of last 4 weeks in each dial guage visual ( only for handled and transferred users)

 

Please help me how can i perform different operation on same visual .

 

vmware-view_2019-12-05_17-35-22.pngImage 1vmware-view_2019-12-05_17-26-38.pngImage 2

1 ACCEPTED SOLUTION

Accepted Solutions
kparab Frequent Visitor
Frequent Visitor

Re: I want display data in dial guage for two different ways

Hi ,

 

I am able to show default values in dial guage by excluding handled and transferred  , but i am facing problem for - if i select handled and transferred from slicer then the dial guage values becomes Blank , but it should give me average of overall for handled and transferred there.

 

i.e. 1. By default - handled and transferred should be excluded

     2. On selection of slicer - it should calculate average of handled and transferred overall.

 

Please help me!!

View solution in original post

5 REPLIES 5
Highlighted
v-jayw-msft Senior Member
Senior Member

Re: I want display data in dial guage for two different ways

Hi  @kparab ,

 

If i understand you correctly, you can use ISFILTERED() function to exclude handled and transferred user by default.

For Example:

IF(NOT(ISFILTERED('Tablename'[Columnname])),ResultIfTrue,ResultIfFalse)


Best Regards,

Jay 

Community Support Team _ Jay Wang

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

 

 

kparab Frequent Visitor
Frequent Visitor

Re: I want display data in dial guage for two different ways

Hi ,

 

I am able to show default values in dial guage by excluding handled and transferred  , but i am facing problem for - if i select handled and transferred from slicer then the dial guage values becomes Blank , but it should give me average of overall for handled and transferred there.

 

i.e. 1. By default - handled and transferred should be excluded

     2. On selection of slicer - it should calculate average of handled and transferred overall.

 

Please help me!!

View solution in original post

v-jayw-msft Senior Member
Senior Member

Re: I want display data in dial guage for two different ways

Hi @kparab ,

 

If I understand you correctly, you will need to create a measure using SELECTEDVALUE() function to get the selected value and ISFILTERED() function to determine if the slicer is filtered.

Please refer to below measure and the result would be show as below.

Measure = 
IF (
    ISFILTERED ( 'Table 2'[Name] ),
    CALCULATE (
        AVERAGE ( 'Table'[amount] ),
        FILTER ( 'Table', 'Table'[Name] = SELECTEDVALUE ( 'Table 2'[Name] ) )
    ),
    CALCULATE (
        AVERAGE ( 'Table'[amount] ),
        FILTER ( 'Table', 'Table'[Name] <> "D" )
    )
)

1.PNG

2.PNG
BTW, Pbix as attached, hopefully works for you.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

kparab Frequent Visitor
Frequent Visitor

Re: I want display data in dial guage for two different ways

Thank you so much ...It worked

v-jayw-msft Senior Member
Senior Member

Re: I want display data in dial guage for two different ways

Hi @kparab ,

 

Could you please mark my answer as a solution if it solved your problem😁.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)