The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Beginner here,
I have a table of items, with: ID's, Names, Purchase quantity and Purchase Dates. Many items were bought on the same day.
I want to be able to filter the items so the return graph show:
X = Dates between first and last Purchase date (Returns all dates, regardless if 0 items were bought)
Y= The count of items purchases on each date (not quantity - the amount of times a date occurs)
What is the approach I would do to achieve this? I have a date table linked with Purchase dates but no matter what it returns BLANK.
It's trivial but nothing I do seems to work.
Thanks.
Thanks.
Solved! Go to Solution.
@HotChilli Thanks for your contribution on this tread.
Hi @BaileyL ,
You can create a measure as below and apply the measure onto your visual to get it:
Measure = DISTINCTCOUNT('Table'[ID's]) +0
Best Regards
@HotChilli Thanks for your contribution on this tread.
Hi @BaileyL ,
You can create a measure as below and apply the measure onto your visual to get it:
Measure = DISTINCTCOUNT('Table'[ID's]) +0
Best Regards
Sample data would help.
What visual are you using?
What have you got in the field well for each axis? (if it's a chart).
If using a date table, have you double-checked that the relationship is working?
What is the expected result?