Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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."
Solved! Go to Solution.
Measure for your card:
Measure = VAR NumCalls = SUM ( Table1[Answered Calls] ) RETURN IF ( NumCalls = 0; "hasn't answered any calls"; NumCalls )
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?
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"
Measure for your card:
Measure = VAR NumCalls = SUM ( Table1[Answered Calls] ) RETURN IF ( NumCalls = 0; "hasn't answered any calls"; NumCalls )
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)
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.
Afte I do that its giving errors
Thank You so much
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |