The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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
Solved! Go to Solution.
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])
Am I able to bump this? 🙂
Hopefullly with th video examples I have added someone might be able to help.
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])
Thank 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?
Can you show me a screenshot of the report with the columns used from the right pane?
Hello, I am having this same issue where the measure says "contains" but nothing drops down. I need to "distirbutor PTR" card to not display anything until the below filters are selected. Preferably until all filters except the last one are filtered.
Its definitely an issue with the card visual because I also noticed it works for graphs but not the card.
User | Count |
---|---|
58 | |
56 | |
55 | |
50 | |
32 |
User | Count |
---|---|
172 | |
89 | |
70 | |
46 | |
45 |