Forum Discussion
Month wise Data not getting due to modeling
i have one data to buid hai report but not know how
please help this kind of data
to arranger data
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.
2 Replies
- lbendlin
Super User
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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 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.
