Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Is there any way we can apply a filter on the values that are being shown in a column in a table?
For example, I have a customer column and I am calculating there rolling 12 months sales and I am also calculating there previous 12 rolling month sales. So when I put these 2 measures in a table with customer column it also starts showing my customer from beyond rolling 12 months. I have tried putting conditions where rolling 12 months is blank but showing wrong results. Any advice?
Currently, there is only a single table for all this so no data model is there.
Hi @Pulkit,
Do you means use filter/slicer to interaction with clause column/table to make them 'dynamic'? If this is a case, current power bi does not support this, they are stored on different data levels and not able to use the child level to effect its parent.
Notice: the data level of power bi.
Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> virtual table of data view(measure, visual, filter, slicer)
Regards,
Xiaoxin Sheng
@Pulkit , Not very clear
Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.
If your measure
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],max('Date'[Date],-12,MONTH))
Rolling 12 till last 12 month = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],max(dateadd('Date'[Date],-12,month)),-12,MONTH))
Measure =if(isblank([Rolling 12]),blank(),[Rolling 12 till last 12 month])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
107 | |
69 | |
68 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |