Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello guys,
I need to dynamically show and hide differents R visuals based on the selection in one slicer. I'm looking for a way to chage the dimensions (width and height), the position, or just make on R visual completelly transparent.
Anyone of you did this before?
Thanks in adavenced.
Solved! Go to Solution.
Hello @v-shex-msft and thaks for your support, I'm out of time now and I kinda solve my problem creating differente visuals , using bookmarks unckecking the data option and with different buttons triggering those bookmarks. Anyway I'd try your suggestion for a v2 of my model.
Thanks to all!
Hi @SebastianLM,
In my opinion, you can try to write a measure to check selected value and return tag.
Then drag this measure to visual level filter to R visual, use advanced filter mode with tag value to control display status of records in R visual.
Regards,
Xiaoxin Sheng
Hello @v-shex-msft and thanks for your reply,
I created the tag measure and put it in to the visual level filter, but I'm not sure what do you mean with "advanced filter mode with tag value to control display status of records in R visual". Could you please explain me this a lil bit more?
Hi @SebastianLM,
You can write measure with dax function to create variable to stored selected value form slicer. Add if statement to check selected value, if matched to condition, return 'Y', other return 'N'.
After above steps, drag this measure to visual level filter of R visual.
Switch filter mode to 'is', filter item to 'Y'. Then you can use slicer to control R visual display or not display records.
Regards,
XIaoxin Sheng
Hello @v-shex-msft and thaks for your support, I'm out of time now and I kinda solve my problem creating differente visuals , using bookmarks unckecking the data option and with different buttons triggering those bookmarks. Anyway I'd try your suggestion for a v2 of my model.
Thanks to all!
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |