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.
hello everyone,
i ceated a line chart:
all is correct im not facing issues but all i want is the first line per product to go from 0 so expected result:
the line should alwayss go from 0 to the number per product on the first appearance
Hi @eliasayyy
It could be possible. Can you please advise which columns are involved in this visual and from which tables? Specifically the x-axis
x-axis is month-year column formated from date
format(table[date],"MM-YYYY")
y axis is a formula measure to calculate sum by month-year
all from 1 table called table
which has 3 columns : date , product and sales
i added calculated column of
month-year
sorting
the measure is calculate(sum(table[sales]),datesbetween(date,startdate,enddate))
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |