Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to filter the columns of a table based on the first value of each column. Each of these columns have a variety of values inside them but the first value is always a date, based on a date filter I'd like to filter out the columns whose dates do not match with the selected value on the filter.
The expected result would be that columns 4, 5 & 6 only show up when the selected date is December 2023.
Thank you in advance.
Solved! Go to Solution.
Hi @armonz ,
With the information available, it would be difficult to achieve your results. I would still recommend that you apply slicer after transposing in Power Query, which will put the date into a column.
Here is my sample data:
After transpose:
Then I create this measure:
Measure =
IF(
YEAR(MAX(Transpose[Column1])) = SELECTEDVALUE(Slicer_Year[Year]) && MONTH(MAX('Transpose'[Column1])) = SELECTEDVALUE(Slicer_Month[Month]),
1,
0
)
Put this into the "Filters on this visuals":
And set it as this way:
The final output is as below:
And there is another way. However, this method was only tried on a small portion of the data.
For example:
Create bookmarks for these table visuals:
Create buttons for each bookmark:
Please refer to this post for the exact steps:
Solved: chart type change on published bookmarks - Microsoft Fabric Community
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @armonz ,
With the information available, it would be difficult to achieve your results. I would still recommend that you apply slicer after transposing in Power Query, which will put the date into a column.
Here is my sample data:
After transpose:
Then I create this measure:
Measure =
IF(
YEAR(MAX(Transpose[Column1])) = SELECTEDVALUE(Slicer_Year[Year]) && MONTH(MAX('Transpose'[Column1])) = SELECTEDVALUE(Slicer_Month[Month]),
1,
0
)
Put this into the "Filters on this visuals":
And set it as this way:
The final output is as below:
And there is another way. However, this method was only tried on a small portion of the data.
For example:
Create bookmarks for these table visuals:
Create buttons for each bookmark:
Please refer to this post for the exact steps:
Solved: chart type change on published bookmarks - Microsoft Fabric Community
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, couldn't get the expected result, but this got me the closest to it.
Hey @armonz ,
a well-defined semantic model (okay, sometimes a model is enough) is the foundation of simple but powerful data analysis using Power BI for this reason I recommend these two articles:
Next to that, it will help us to understand your requirement way more better if you provide sample data, ideally in pbix file that represents your data model (tables, relationships, calculated columns, and measures) that we can dwnload from OneDrive, Google Drive, or dropbox.
Regards,
Tom
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |