Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
@ymulyana wrote:
I have a situation where users want the ability to have a column change the data presented based on a slicer selection. The analogy would be: 1. Table Sales Consist of :
Period Group Year Sales
MAT A 2014 10
MAT A 2015 15
MAT B 2014 12
MAT B 2015 14
MAT C 2014 6
MAT C 2015 8
YTD A 2014 10
YTD A 2015 15
YTD B 2014 12
YTD B 2015 14
YTD C 2014 6
YTD C 2015 8
in this sample same as : https://community.powerbi.com/t5/Desktop/Dynamic-Column-Based-on-Slicer-Selection/td-p/81126 But in more compleks columns. Any thoughts on how to do this?
The case in that link has 3 tables, could you post more details about your case, what is your expected output?
I would be interested in knowing if there is a solution for this as well.
My case is let's say I have the following three dimensions for sales data
1. Category
2. Product
3. Subproduct
And I have the following measure
1. Sales
What I want to do is provide the user a slicer that has a dropdown that contains the values "Category", "Product", "Subproduct"
When the user selects "Category" then a table shows
1. Category
2. Sales (Aggregated by Category)
When the user selects "Product" then a table shows
1. Product
2. Sales (Aggregated by Product)
In tableau, this is fairly straightforward but not in PowerBI and I am curious if PowerBI supports this use case.
thanks
Hi @powerbitz,
I dont think that is possible. One will have to manually drag the dimension to the visual.
@powerbitz can you share sample data in excel thru google drive or other means.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |