cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cham Member
Member

0 values

Hi,

 

I have a data set which includes answered and unanswered call details.

 

If i select one user name it will show "0' because that user didnt answer any calls. So, I want to show a card showing that "this user did not answer any calls at this moment".

 

If the user select that particular user name if filter slicer, card need to be show automatically saying that "this user did not answer any calls."

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: 0 values

@cham

Measure for your card:

 

Measure =
VAR NumCalls =
    SUM ( Table1[Answered Calls] )
RETURN
    IF ( NumCalls = 0; "hasn't answered any calls"; NumCalls )
7 REPLIES 7
Super User
Super User

Re: 0 values

Hi @cham

You'd have to provide more info on your tables/ data model so that we can get a detailed answer. Can you show a sample?

 

 

cham Member
Member

Re: 0 values

Hi,

 

This is the sample data set. If I select user name as "C" in my filter slicer then i want to show a card that showing "he is not answered any calls"

 

0 values.PNG

Highlighted
Super User
Super User

Re: 0 values

@cham

Measure for your card:

 

Measure =
VAR NumCalls =
    SUM ( Table1[Answered Calls] )
RETURN
    IF ( NumCalls = 0; "hasn't answered any calls"; NumCalls )
cham Member
Member

Re: 0 values

Thank You so much

cham Member
Member

Re: 0 values

Hi @AlB

 

I want to know the following thing as well.

After I upload the below excel sheet into power bi it will show an error in the highlighted row.

How can i change the data type in Power BI as dd:hh:mm:ss?( days, hours, minitues and seconds)

 

DD-HH-MM-SS.PNG

Super User
Super User

Re: 0 values

@cham

 If you select the column with the issue and go to the 'Modelling' pane you have  'Data type' and 'Format'. You can see the options for the format there.

cham Member
Member

Re: 0 values

Afte I do that its giving errors