Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a date set with 3 columns: Category, Date and Event Count.
I would like to create a summary table on my dashboard where the first column is Category, second column is total of event count based Date1, third column is total of event count based on Date 2.
I want Date 1 and Date 2 to be chosen by user. Of course Date 1 and Date 2 must be limited by the available dates in the data
How do I create such paramters. I can do that in Tableau but not sure how to achieve the same object with Power BI?
Thanks
have you found a soluton to this? i have the same problem i'm trying to solve
hi, @rosesmary
You can try to use Parameters in Power BI Edit Queries. here is the tutorial for you to refer to:
Reference:https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/
Best Regards,
Lin
@rosesmary Any sample data and expected output will be helpful
Proud to be a PBI Community Champion
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |