Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a requirement to drag and drop a dimension (Ex: DateTime, Region dimension) into the Power BI dashboard like in Qliksense? The data should get filter based on the chosen dimension. How do you achieve this in Power BI? Please provide samples, if any. Thanks in advance.
Solved! Go to Solution.
Hi @Nambidasan ,
Here's a similar post which provided a valid solution with dynamic x axis.
Solved: Dynamic change in X Axis - Microsoft Power BI Community
The sample file is in the post and you can download it.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Nambidasan
If you are developing a report then you can drag and drop fields on to visuals but as an end user, it's not possible. However, if the ned user needs to choose the fields to drag and drop as you desire then Personalize Visual option would be the solution: https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-personalize-visuals?tabs=powerbi-d...
Also, you can try the New Field Parameter: https://www.youtube.com/watch?v=V6WchPDZibI
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Fowmy Thanks for your response. I was looking for something like below. Like in Qliksense, we have an option to drag and drop the dimension (As a end user) and the data changes according to the dimension chosen in the visual. In a broader view, I wanted to bring all my dimensions(apprx 20 dimensions) into the visuals and the end user should have an option to change the visual as per the chosen dimension. Any small samples (which works as per the second link) would work for me. Thanks in advance!
Hi @Nambidasan ,
Here's a similar post which provided a valid solution with dynamic x axis.
Solved: Dynamic change in X Axis - Microsoft Power BI Community
The sample file is in the post and you can download it.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |