Data segmentation default / Segmentación de datos por default

[MidnaJazz08]

Hi Firends!

Please I need your help, I would like to know how I can show the data of the current month in my data segmentation. These currently show all the information from my dimension tables.

*****************************

Hola amigos!

Por favor necesito su ayuda, me gustaría saber cómo puedo mostrar en mi segmentación de datos los datos del mes en curso. Actualmente, estos muestran toda la información de mis tablas de dimensiones.

[amitchandak]

@MidnaJazz08 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

In case you are looking for

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

[MidnaJazz08]

Sure!

I have October customers A, B, C, but in my dimension I have A, B, C, ...., Z customers, when I use the data segmentation this shows all customers in my dimension not only of customers of October how should it be. I did a default measures like number of ticket of month:

Mes default (NumTick) = IF(
    NOT(ISFILTERED('Tabla Calendario'[Date].[Mes])),
    CALCULATE(COUNT(Consolidados[Ticket#]),FILTER('Tabla Calendario','Tabla Calendario'[Offset de mes actual]=-1)),
    COUNT(Consolidados[Ticket#]))

[v-yingjl · Accepted solution]

Hi @MidnaJazz08 ,

Still not certain what is your expected output and the table structure look like.

Based on the measure, seems like there is a date table and a source table in the report, suppose there is a date column in the source table but without relationship.

You can try to use this measure to filter the visual:

Visual = 
IF(
    SELECTEDVALUE('Date'[Date].[MonthNo]) = MONTH( MAX('Table'[Date])) &&
    SELECTEDVALUE('Date'[Date].[Year]) = YEAR(MAX('Table'[Date])),1
)

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.