Forum Discussion
Better Option to select Fields?
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?
8 Replies
Anonymous you need to transform the data in unpivot format to achieve it.
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.
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
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/
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.
