Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Expert,
1st step to create calendar using below mentioned scripts . which will give hirachy also
Table2 = CALENDAR(DATE(2016,1,1),DATE(2019,12,31))
2nd step create a column
Format('Table 3'[Date],"MMM-YY")
and add month- year column in hirarchy or tell me the alternate step where we can add month-year column in hirarchy
Shree
Solved! Go to Solution.
Hi @Anonymous
You could add date column in a table or matrix visual, then select "date hierarchy".
if you want the month to display as "MMM-YY" format, you could create the table as below
Table2 = ADDCOLUMNS ( CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2019, 12, 31 ) ), "year", YEAR ( [Date] ), "month", MONTH ( [Date] ), "day", DAY ( [Date] ), "MMM-YY", FORMAT ( [Date], "MMM-YY" ), "quarter", SWITCH ( TRUE (), MONTH ( [Date] ) <= 3, "Qtr 1", MONTH ( [Date] ) <= 6, "Qtr 2", MONTH ( [Date] ) <= 9, "Qtr 3", MONTH ( [Date] ) <= 12, "Qtr 4" ) )
Hi @Anonymous
You could add date column in a table or matrix visual, then select "date hierarchy".
if you want the month to display as "MMM-YY" format, you could create the table as below
Table2 = ADDCOLUMNS ( CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2019, 12, 31 ) ), "year", YEAR ( [Date] ), "month", MONTH ( [Date] ), "day", DAY ( [Date] ), "MMM-YY", FORMAT ( [Date], "MMM-YY" ), "quarter", SWITCH ( TRUE (), MONTH ( [Date] ) <= 3, "Qtr 1", MONTH ( [Date] ) <= 6, "Qtr 2", MONTH ( [Date] ) <= 9, "Qtr 3", MONTH ( [Date] ) <= 12, "Qtr 4" ) )
Please check if this can help
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |