The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Im trying to create a dynamic table, that returns a value based on the slicer selection. In a scenario, I want to show what were the projected sales number from previous 4 weeks, to see the change in numbers. Slicer selection = Current date in table
The return value is also based on the slicer selection, and the date version. And the data will change based on the slicer, while the rows in the table is essentially D-7, D-14, D-21, D-28 (previous weeks). Seems quite a complicated task to do in PBI.
I tried using SELECTEDVALUE, but I think it didnt work. Im attaching a saple of data and what it supposed to look and work as a dashboard in excel
Uploaded a sample of the file
Solved! Go to Solution.
Create a switch measure as below,
Days =
Hi,
I have solved a similar problem in the attached PBI files.
Hope this helps.
Create a switch measure as below,
Days =
Hi Bmejia, could you share your PBI file as well? Im having difficulties in getting the correct format to show the table
Sorry, I am not able to upload files like others in the forum
Maybe this will make more sense.
1st just add a table and add your fields Input Week, Project Sales. (This will show everything)
2nd Add a dropdown filter and add the Sales Week field
3rd Create measure above and add to table
4th go to the filter pane and look for days and filter by “is not” 0 (as print screen above).
5th you should only be able to see the date ranges 7,14,28 etc.. every time you filter by Sales Week selected.
That worked a treat. Thanks so much!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.
User | Count |
---|---|
138 | |
109 | |
83 | |
69 | |
59 |
User | Count |
---|---|
258 | |
128 | |
116 | |
100 | |
80 |