The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi everyone.
I am triyng to get a slicer data type to change dynamically according to the value selected in another slicer and would appreciate some guidance on how to solve.
Picture 1: This is the basic data I am working with
Picture 2: I took the table from picture 1 and added a few more steps as follows:
My problem is that i am not able to change the data type for the "Value Legends" and "Value Categories" to "Date Type" or "Text Type" depending on the selection made on the attribute slicers.
Any guidance with either or both woud be highly appreciated.
Solved! Go to Solution.
Hi @miltonayala,
I'm afraid it is not possible to dynamically change the data type of values shown in slicer. In this workaround, it looks like fields displayed in slicer are dynamic, actually, all displayed selections in slicer are from a single column. But one column can have only one data type. Based on my test, there is no workaround to achieve such a requirement.
Regards,
Yuliana Gu
Hi @miltonayala,
I'm afraid it is not possible to dynamically change the data type of values shown in slicer. In this workaround, it looks like fields displayed in slicer are dynamic, actually, all displayed selections in slicer are from a single column. But one column can have only one data type. Based on my test, there is no workaround to achieve such a requirement.
Regards,
Yuliana Gu
Is it not possible for you to relate 2 tables and use Edit Interactions so that your slicers dynamically change based on each other.
Regards
@Anonymous
Thanks for your comment, however it was already done (through a workaround) in the option shown in the picture 2. In that option my issue is how to dynamically change the data type for the new slicer.
Any thoughts?
I would like to dynamically change the data type of a slicer based on the selection on another slicer and would appreciate any help or guidance on the topic. Date type is currently shown in as text (in picture 2) but I need it to change to date or text and date dynamicaly depending on the value on the independent slicer. Any suggestions would be highly appreciated.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
96 | |
80 | |
62 | |
56 |
User | Count |
---|---|
256 | |
120 | |
112 | |
83 | |
71 |