Better Option to select Fields?

Anonymous · ‎04-11-2020

Hi, New PowerBI user converting from Tableau.

I have an Excel data source that has sales measures for latest 4, 13, 26 and 52 weeks. The problem is that my data fields are already labeled as SALES - CUR 52, SALES - YAG 52, SALES - CUR 26, SALES - YAG 26 and so on. I also have other fields like Units, Average Retail price, ACV, Promo Units, etc. and all of these have the same 4, 13, 26 and 52 week options.

See snapshot of the measures I have already added to a report.

I would like to let the user select something like a parameter (thinking from Tableau days) or a filter for the 4, 13, 26 or 52 week time frame and the report only shows those fields.

Any thoughts?

v-yuta-msft · ‎04-13-2020

@Anonymous ,

Yon can change the measures based on selections in the slicer using dax expression like pattern in blogs below:

https://www.burningsuit.co.uk/blog/2018/03/dax-how-to-use-a-slicer-to-select-different-measures/

http://excel-inside.pro/blog/2017/04/07/dynamically-select-measures-to-be-shown-on-a-power-bi-visual...

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak · ‎04-11-2020

@Anonymous , As @parry2k already suggested better to unpivot and create measure as dimension and choose those. You can use measures slicer but option are limited

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

Refer: https://radacad.com/pivot-and-unpivot-with-power-bi

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

parry2k · ‎04-11-2020

@Anonymous you need to transform the data in unpivot format to achieve it.

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.

Anonymous · ‎04-11-2020

Hi parry2k.....Since I am new to PowerBI I have no idea how to do that. Any help is appreciated!

parry2k · ‎04-11-2020

@Anonymous may be bit hard to explain here if you can share sample data/pbix file (remove sensitive info before sharing) and I will get you the solution.

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.

Anonymous · ‎04-13-2020

@parry2k Here is link to my .pbix file:

Please help

https://1drv.ms/u/s!AtNzKwvfh50Pi_ACyJVCFKrr5aVr5w?e=oddobK

Anonymous · ‎04-17-2020

Still looking for help on how to complete the Power Query portion of this. I took @parry2k steps and then started applying to my entire data source but I am stuck. How can I share my whole bi file and anyone else who could assist me?