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 using the Card Visulization and one of the fields that I am putting on the field section is called End Date ( I am selecting the Earliest )
.
This End Date does have some dates for some people when I filter on their name but when I select a person that has their End Date as blank it shows it on the Card as the below
How do I make it just showing nothing i.e. no text just a White Box
Thanks
Solved! Go to Solution.
If you are talking about selecting a slicer, you want your measurement to come back blank when the row is empty, then do not do it if the condition because you are going to find it blank or you need to add a SELECTED VALUE to your measure.
Example:
Can you share a sample? it would be easier to understand this way
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @AvPowerBI
Just white box, no not possible...but you can replace the Blank by some term of your choice, you will need to add a DAX measure using IF condition to the calculation.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
I created a New Column with the below IF Statement
Thanks
No,
You need to add a measure not a calculated column, using Min(date) or EARLIER, EARLIEST...
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
I have created a measure instead (though the field I am using is a Date field?)
Has it something to do with my DAX or not possible with Date Types
If you are talking about selecting a slicer, you want your measurement to come back blank when the row is empty, then do not do it if the condition because you are going to find it blank or you need to add a SELECTED VALUE to your measure.
Example:
Can you share a sample? it would be easier to understand this way
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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 |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |