Power bi scenario

[Sreekanth910082]

•  How to Display Monthly Sales and Cumulative Sales Horizontally in Power Bi
• 

   

  Question:Hi everyone,I'm working on a Power BI project and need some help with displaying monthly sales and cumulative sales horizontally. Here's what I've done so far:I have a dataset with columns for Date and Sales.I've created Month and Year columns using DAX expressions:Month = FORMAT('YourTableName'[Date], "MMM")

Year = YEAR('YourTableName'[Date])I've also created measures for Month-wise Sales and Cumulative Sales:MonthWiseSales = SUM('YourTableName'[Sales])

CumulativeSales = 

CALCULATE(

    [MonthWiseSales],

    FILTER(

        ALLSELECTED('YourTableName'),

        'YourTableName'[Date] <= MAX('YourTableName'[Date])

    )

)I'm able to create a table visualization and display these measures, but I'm struggling to ensure the table shows the data horizontally (with months as columns).Can anyone guide me on how to achieve this in Power BI? Any tips or best practices would be greatly appreciated!Thanks in advance!Feel free to adjust the details to better match your specific scenario.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check below picture and the attached pbix file.

[Sreekanth910082]

Dear Jihwan_Kim,

I wanted to extend my sincere thanks for taking the time to provide a solution to my question in the Power BI Community. Your expertise and willingness to help are greatly appreciated. The solution you provided was clear and effective, and it has really helped me move forward with my project.

Once again, thank you so much for your assistance!