topic Re: How to display the data with specific period as default to the dashbord in Custom Visuals Development Discussion

How to display the data with specific period as default to the dashbord

Anonymous — Thu, 12 Dec 2024 15:15:30 GMT

Hi Team,

I'm using a specific measure that is return True/Fasle. I want the dashboard to present the data that is related to the True values how to set this setting without using the filter in the dashboard because I'm using a sliver to filter the period and whenever the user choose a specific year the dashboard will be filtered in the chosen year ?

Re: How to display the data with specific period as default to the dashbord

anilelmastasi — Sat, 12 Jul 2025 17:13:25 GMT

Hello @Anonymous ,

If you're writing a measure like:

TotalSales = SUM(FactSales[Amount])

You can wrap the measure in a filter that returns only rows where your Boolean condition is true.

Assume you have a measure:

[IsQualifiedCustomer] =
Some condition returning TRUE or FALSE

Then use:

TotalSales_OnlyQualified =
CALCULATE(
SUM(FactSales[Amount]),
FILTER(
ALL(FactSales),
[IsQualifiedCustomer] = TRUE()
)
)

This ensures that only rows where [IsQualifiedCustomer] is TRUE() are included in the calculation, regardless of visible filters. And it respects slicers like Year or Period — because those apply outside the CALCULATE context unless removed with REMOVEFILTERS() or ALL()

If this solved your issue, please mark it as the accepted solution. ✅

Re: How to display the data with specific period as default to the dashbord

raju8004212 — Sat, 23 Aug 2025 10:22:51 GMT

Hi @Anonymous

please follow below steps it will help you solve.

If you want all visuals on a page/report to be restricted to TRUE rows (like RLS, but not user-based), you can create a calculated table that contains only the TRUE rows:

FilteredData =
FILTER ( OriginalTable, [MyCondition] = TRUE )

Then build your visuals on top of FilteredData instead of the raw table.