text
4 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.4KViews0likes5CommentsClear a Search text box in a slicer field
Hi , The search text entered in the slicer won't clear even after hitting eraser OR using book mark to clear default selection . We're seeing this issue on both on Power BI Desktop and Power BI Report Server ( not sure about Power BI Service, because we're using On premise PBI Report server ). Could you please let us know the solution to fix this issue . If this is expected behavior, kindly fix this in upcoming versions . Thanks in advance !3.9KViews0likes4CommentsText Filter visual not working in Report Server? Alternative?
Can anyone confirm if the Text Filter visual (Version: 1.2.1) is supported on Report Server? Works great on Desktop but does not appear when publishing to Report Server. If the answer is no, any suggestion on how to implement a basic text search on report server? I know I can turn on search in a slicer, but dont want to show search results as a drop down in the slicer (search results are shown in a separate table visual) Thanks979Views0likes2CommentsDisplaying a text column in a measure/matrix
Hello, I have a measure I am using in a matrix as kind of a summary for multiple companies. I am using switch for the column headers and then I have multiple different CALCULATION functions for displaying what I need. However I am having trouble displaying a column that is supposed to show the category for the companies. The data is text. I have tried SELECTEDVALUE and that works if I have slicer and pick that specific category but I want to show the matrix for all categories at the same time, any ideas? Thanks 🙂2KViews0likes4Comments