Month wise Data not getting due to modeling

[Anonymous]

i have one data to buid hai report but not know  how

please help this kind of data

to arranger data 

[Anonymous · Accepted solution]

Hi @Anonymous ,

In general, we can't directly filter the month by the row values in the month column.

There are two ways to solve it:
1. Do unpivot columns in Power Query in advance, and turn the month column into a month row, so that you can use the month column as a field for slicing for filtering.

Steps:

Select month columns and click unpivot columns.

Then you can use the attribute colum as the field of the slicer for filtering.

2. Learn about the field parameter function, which can turn the month columns into parameters and use them as a slicer filter.

Reference:

Unpivot columns - Power Query | Microsoft Learn

Use report readers to change visuals (preview) - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...