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 All,
I'm a Power Bi novice! I have established a Power Bi report, and within the report I am counting the text value for a 'Completed' column. The text results are only 'True' or 'False'.
I have a count of all occurances which works fine, I am then counting all "True" values, all "False" values and all "False" values that are before today's date. As pictured below.
When I publish the report to My Workspace, the report initially shows as desired. When a dataset refresh occurs, I keep receiving the below result.
Does anyone know how to fix this issue? I've tried to create new columns, measures, etc. to no avail. I can't find an answer anywhere.
Any help is appreciated!
Solved! Go to Solution.
Fixed the issue! Converted the column to True/False data type, then used a measures to get count:
TrueCount = COUNTAX(FILTER('Table',[Completed]=TRUE()),TRUE())
And a measure so the card shows as '0' not '(Blank)' if no data:
TrueCountIf = IF('Table'[TrueCount]>=1,[TrueCount],0)
Hi,
You can hide the blank value using a Conditional Formatting rule on the Callout Value. The rule is 'if blank' then select the same color as the card or canvas background.
I have created a video tutorial on how to create the conditional rule: https://youtu.be/Xsmbfpa4oCA
Fixed the issue! Converted the column to True/False data type, then used a measures to get count:
TrueCount = COUNTAX(FILTER('Table',[Completed]=TRUE()),TRUE())
And a measure so the card shows as '0' not '(Blank)' if no data:
TrueCountIf = IF('Table'[TrueCount]>=1,[TrueCount],0)
Hi @jake97
How are you counting the values that show as BLANK?
After the data refresh, what data is in your dataset? Can you please provide this data.
Regards
Phil
Proud to be a Super User!
Hi @PhilipTreacy, thank you for your response!
There are no blanks in the column I am counting. The data is populated from a SharePoint list, the default for "Completed" is FALSE (No).
Below is what the data looks like for the column I'm counting.
Is there anything else I can provide you with?
Thank you very 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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |