Forum Discussion
Continued ContributorUsing slicers to populate or enter data into tables
Very new to PowerBI.
Here are links to .PBIX and .XLS table, respectively for reference.
https://www.dropbox.com/s/rbjoqspdjdmtquq/Power%20BI%20Forum%20Sample.pbix?dl=0
https://www.dropbox.com/s/5vobo0j9b1j72hk/Slicer%20Inputs.xlsx?dl=0
I have a dashboard with one chiclet slicer, and 5 slider slicers.
- Project Number [chiclet slicer]
- Acquisition Cost
- Revenue Yield
- Start Month
- Start Year
- Duration (mos)
From these inputs, I'd like to generate a new table that looks loosely as follows. Then when I select a different Project Number, I'd like it to add the different inputs to the Table below. On a related note, is it possible to change the "Project Number" slicer to a "Project Name" from a dropdown list?
| Project Number | Acquisition Cost | Revenue Yield | Start Month | Start Year | Duration | Count | Calendar Date | Revenue | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 1 | 5/31/2019 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 2 | 6/30/2019 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 3 | 7/31/2019 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 4 | 8/31/2019 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 5 | 9/30/2019 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 6 | 10/31/2019 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 7 | 11/30/2019 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 8 | 12/31/2019 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 9 | 1/31/2020 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 10 | 2/29/2020 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 11 | 3/31/2020 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 12 | 4/30/2020 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 13 | 5/31/2020 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 14 | 6/30/2020 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 15 | 7/31/2020 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 16 | 8/31/2020 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 17 | 9/30/2020 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 18 | 10/31/2020 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 19 | 11/30/2020 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 20 | 12/31/2020 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 21 | 1/31/2021 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 22 | 2/28/2021 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 23 | 3/31/2021 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 24 | 4/30/2021 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 25 | 5/31/2021 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 26 | 6/30/2021 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 27 | 7/31/2021 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 28 | 8/31/2021 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 29 | 9/30/2021 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 30 | 10/31/2021 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 31 | 11/30/2021 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 32 | 12/31/2021 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 33 | 1/31/2022 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 34 | 2/28/2022 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 35 | 3/31/2022 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 36 | 4/30/2022 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 37 | 5/31/2022 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 38 | 6/30/2022 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 39 | 7/31/2022 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 40 | 8/31/2022 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 41 | 9/30/2022 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 42 | 10/31/2022 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 43 | 11/30/2022 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 44 | 12/31/2022 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 45 | 1/31/2023 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 46 | 2/28/2023 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 47 | 3/31/2023 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 48 | 4/30/2023 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 49 | 5/31/2023 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 50 | 6/30/2023 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 51 | 7/31/2023 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 52 | 8/31/2023 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 53 | 9/30/2023 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 54 | 10/31/2023 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 55 | 11/30/2023 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 56 | 12/31/2023 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 57 | 1/31/2024 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 58 | 2/29/2024 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 59 | 3/31/2024 | 0.5 | |
| 2 | 50 | 1% | 5 | 2019 | 60 | 60 | 4/30/2024 | 0.5 | |
| end | |||||||||
2 Replies
v-piga-msftResident Rockstar
Hi mrothschild,
I have a little confused about your scenario.
As I understand, do you want to get the dropdown slicer like below?
In addition, it seems that you want to get the output you post.
If it is, please refer to the Page 4 in my attachment.
If you still need help, please describe the logic which could get your desired output in more details so that we could help further on it.
Best Regards,
Cherry
mrothschildThank you, and apologies for the delayed response, I was traveling yesterday.
Your Page 4 is helpful and a great start, but not quite the solution.
The calendar month in your Page 4 starts at 10/31/18, and I want it to start, per the slide at May 2019 - I'll add in EOMONTH( ) to resolve the day.
In the table in my original post, I showed monthly revenue of 0.5, which was the 1% [Revenue Yield] Value in your slider * the 50 of [Acquisition Cost] value.
Lastly, what I'd like is to be able to add project, say 37, and append all the data shown on Page 4 to either an existing table, or create a new table from it that I can then use for visuals on Page 2.
Thanks!