Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a table from a select query that has 3 columns date, units, and count.
date units count
20160225 1 1
20160226 1 1
this is how it looks in the table
What I'm trying to do is create a chart that will display the dates and the units or the count. I need to use either a parameter or a filter but I'm not sure what is the best. I need to be able to select from a filter or a parameter units; and the line graph will generate a graph for the units, then if I need to select count the graph will change using the count. Can someone please help?
Thank you,
Antonio Fallucca
Solved! Go to Solution.
@antoniofallucca,
You can create a disconnected table to achieve the above requirement. for more details, please review the following PBIX file.
https://1drv.ms/u/s!AhsotbnGu1Nogyme9jhSllQtuudL
Regards,
Lydia
@antoniofallucca,
You can create a disconnected table to achieve the above requirement. for more details, please review the following PBIX file.
https://1drv.ms/u/s!AhsotbnGu1Nogyme9jhSllQtuudL
Regards,
Lydia
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
97 | |
88 | |
59 | |
43 | |
40 |