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 am new to Power BI and have an issue where it returns a (blank) when I want to see a 0.
Also, is there an alternatice to using cards where I cam able to right click and See Records?
Thanks in advance and appologies for newbie questions.
If the value shown on the card represents the sum of a column, which is only composed by 0's and 1's, is there a way to solve this? I get that it's easy to do so through a measure, but it would be nice to achieve the same result with columns (in my personal case, purposely created for the instance).
Thanks in advance!
I found the solution (at least for my own problem, might as well be others'):
I was trying to show on multiple cards values that were achieved by summing values from a column through a couple of visual level filters, and some of them were being shown as "(blank)" instead of a plain "0". To solve this, I simply created a measure that summed up the column and added 0:
MEASURE = calculate(sum(TABLE[COLUMN])+0)
Then I replaced the column's sum by the measure I created in the cards. It's working flawlessly.
Great tip. Thanks!!!
perfect solution.
Hi @Beiffon,
Adding to other's post, we are not able to use “See Records” in Card visual. Only the following visual types are supported when using See Records:
• Bar
• Column
• Map
• Tree Map
• Filled Map
• Pie
• Donut
•Funnel
Thanks,
Lydia Zhang
To show zero in a Card just add " + 0 " to your formula!
Otherwise you have test the result of your Measure like this => IF ( ISBLANK ( [Measure], 0, [Measure] )
Thanks,
not really sure how to do this.
I dont have a formula as such its just some visual level filters.
Thanks
You have to create a Measure that duplicates the default behavoir you get when you drag a field to a Card?
That behavior will be sum for a number field and count for text
What is P1 Interactions supposed to show? SUM, Count, DistinctCount, etc?
so if you need SUM your measure would look something like this
P1 Interactions MEASURE = SUM(TableName[ColumnName) + 0
if not you'll have to use the appropriate function to aggregate your values
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 |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |