The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Community,
I have a column that is Date data type . I want to create Start Date and End Date using the same Column . Here , I want Start Date and End date to be Previous Week Monday and Current Week Monday .
I created 2 Calculated columns as shown below .
Solved! Go to Solution.
@Anonymous
The group bin feature for data column will group based on the whole date. Try change the date type to Text, create groups with the text date in the x-axis.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@Anonymous
The group bin feature for data column will group based on the whole date. Try change the date type to Text, create groups with the text date in the x-axis.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Hi Amit,
Yes I have created group(bins) based on Weekend Date as Direct Column of Weekend Date is not grouping data . When I add the new column based of Grouped bins Weekend date, thats where dates appeared differently.
Yes I have turned the Axis type from Continous to Categorical.
Thanks,
G Venkatesh
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
106 | |
96 | |
55 | |
49 | |
46 |