Forum Discussion
Custom column (Recent Date) not working as filter in visual
hi All,
I am working on my first Power BI report.
Requirement is pretty simple.
I have to visual the data for the latest(MAX) date from the table.
Steps I followed:
1. Created a new column MaxReportDate= MAX('table_1'[ReportDate]). This gives me maximum date in the data set.
2. Now in visual, i pull the rest of the data and put this maxReportDate in filter. But nothing happens. the data is not filtered by this column.
3. How ever, If I pull all the report dates in the visual and then click on recent date, it works.
4. I also tried creating another column with below query
Hi Anonymous
1. when we create measure, why is it not seen in data pane (where all columns are seen)?
Measure is different with column.Column could be seen in data table.Measure could be changed with different context in visual.It could be used in visual to get dynamic value.For further,please have a look at below articles to understand it.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
2. I cannot drag this measure under report/page level filter to look for only 1. I have to bring in date and this measure in the visual then filter by 1. I would like to hide this measure from the visual.
is there a way to do this?
You may drag it to visual level filter and set it as 1.
Regards,
3 Replies
v-cherch-msftMicrosoft Employee
Hi Anonymous
You may create a measure with your formula instead of column.Below are some articles about column and measure for your reference.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Regards,
thank you very much..
I have two questions :
1. when we create measure, why is it not seen in data pane (where all columns are seen)?
2. I cannot drag this measure under report/page level filter to look for only 1. I have to bring in date and this measure in the visual then filter by 1. I would like to hide this measure from the visual.
is there a way to do this?
- v-cherch-msft
Hi Anonymous
1. when we create measure, why is it not seen in data pane (where all columns are seen)?
Measure is different with column.Column could be seen in data table.Measure could be changed with different context in visual.It could be used in visual to get dynamic value.For further,please have a look at below articles to understand it.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
2. I cannot drag this measure under report/page level filter to look for only 1. I have to bring in date and this measure in the visual then filter by 1. I would like to hide this measure from the visual.
is there a way to do this?
You may drag it to visual level filter and set it as 1.
Regards,