Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
, first time here,
So i wrote a simple measure, that counts rows apling some simple filters, and placed on a table. However, I want to be able to filter dates using a visual "filter".
I placed the visual "filter" on the project, but when i apply the filter, it doesn't affect the table
Ideas?
Here the measure that i wrote:
contas 1º aporte =
CALCULATE (
COUNTROWS ( 'Base BTG' ),
'Base BTG'[1º Aporte],
'Base BTG'[Aportes] >= 50000,
Originador[Originador] = "sacre digital"
|| Originador[Originador] = "sacre aai"
)
The date that i want to filter is on the 'Base BTG'[1º Aporte].
Here's a print of of the project:
Obs.: just to emphasize, i want the filter to affect the column "Contas Ativadas". As it is right now, the collumn has the content of all dates.
Solved! Go to Solution.
Hello @matheus_mk0 ,
does the table that has the date have a relationship with the table that has the values you want to filter?
because if there's a relation then it should filter.
Proud to be a Super User! | |
Hi,
Simplify your measure to this
contas 1º aporte = CALCULATE(COUNTROWS ( 'Base BTG' ),'Base BTG'[Aportes] >= 50000,(Originador[Originador] = "sacre digital"|| Originador[Originador] = "sacre aai"
))
Also, create a Calendar Table and build a relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table. To your slicer, drag Date from the Calendar Table.
Hope this helps.
Hello @matheus_mk0 ,
does the table that has the date have a relationship with the table that has the values you want to filter?
because if there's a relation then it should filter.
Proud to be a Super User! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |