Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a visualization in which i have two drop down box selection.
the second drop down selections should be based on the first selection and then query database.
e.g. my first selection is 2023 , then the second selection content should be whatever returned from below query
select distinct quarter from myTable where year = selection1Year
how to get this in power bi?
thanks
That is usually achieved through the data model. If your slicer sources are unrelated you can use measures as visual filters. Note: This can only ever go one way.
User | Count |
---|---|
18 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
4 | |
3 | |
2 | |
1 |