visual card
2 TopicsIf date value is not blank return date value if date value is blank return "Text"
Hello I need a measure for a card visual to display a date value if present however if it's blank display a custom text such as "NONE" The date field(expectedresultdate) is a data type of "Date". The custom text if the field is blank is just "Text". Heres what I have. next update = IF(ISBLANK(SELECTEDVALUE('Annual Metrics'[ExpectedResultDate])),SELECTEDVALUE('Annual Metrics'[ExpectedResultDate],"NONE"),SELECTEDVALUE('Annual Metrics'[ExpectedResultDate])) Thank you,Solved1.4KViews0likes5CommentsSlicing by measure not affecting visual card
I have a dataset of purchase order data. In the data I have a measure called 'Score class', which based on the suppliers delivery performance 'PO on time %' gives them a class from A+ to D. I then use that score class measure as a slicer. It works fine on a visual table, but it is not working on a visual card which shows the measure 'PO on time %'. The overall 'PO on time %' from all suppliers is still shown and not the filtered value. Maybe someone could help me in the right direction to achieve want I want. Link to pbix file: Measure as slicer.pbixSolved718Views0likes2Comments