Forum Discussion
Multi X Axis with different Columns/Measures.
Hi Anonymous
You should be able to do that with a dedicated dates table and by using a calculation group. Create calculation groups
Ensure that the table has been marked as such. Set and use date tables in Power BI DesktopSample calclation item formula
QTD = CALCULATE ( SELECTEDMEASURE (), DATESQTD ( Dates[Date] ) )
Please see the attached pbix.
Hi Anonymous ,
Thank you for reaching out to the Microsoft Fabric Community.
As correctly explained by danextian and Nasif_Azam , using a calculation group on the X-axis will display QTD, MTD, YTD, and Year as separate categories in a single visual. Just ensure "Concatenate labels" is turned off if the labels aren’t showing properly.
If you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.