Forum Discussion
Helper IHelp required making a card display empty until filtered by another visual (Video included)
Hi there,
I have a card which I would like to remain totally blank (i.e. not visible) until a different visual is selected. I found it easier to explain rathr thank write out, so I have made a short video and provided a link to Google Drive to view it (hopefully this is within standard procedure on this forum - I was unsure of a better way to do this?)
https://drive.google.com/file/d/117PLwM5tAGXhjZn-oZ_l7iC4cIq18J4X/view?usp=sharing
I have tried using advice from tutorials and this forum to create a measure to help with this task, but I sadly can't seem to get it right. Grateful for any help. Thanks in advance.
Farming BA
Hi. How about counting number of status rows in a measure and use this on the filter spesific for the card visual where you set the argument to "equals 1"?
Status cnt = distinctcount(fact_table[StatusID])
6 Replies
- tt_and
Advocate I
Hi. How about counting number of status rows in a measure and use this on the filter spesific for the card visual where you set the argument to "equals 1"?
Status cnt = distinctcount(fact_table[StatusID])
FarmingBAThank you for the help. Apologies in advance about my basic PowerBi skills.
I have made a new measure using your formula:
I have addd that measure as a filter on my visual:
However, I am unable to change it from "is less than". I've followed a few different tutorial videos, and tried a few different measures which I am confident I have done correctly. However, when I apply them as a filter - the same issue occurs. I am unable to change from "is less than". All other options are greyed out. When I put the measure on a different visual, I can choose from options. So I assume that the card visual I am trying to hide is the problem?
- tt_and
Can you show me a screenshot of the report with the columns used from the right pane?
- FarmingBA
Am I able to bump this? 🙂
Hopefullly with th video examples I have added someone might be able to help.