Forum Discussion

MidnaJazz08's avatar
MidnaJazz08
Frequent Visitor
4 years ago
Solved

Data segmentation default / Segmentación de datos por default

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.

 

 

Need Help
Tutorial Requests
  • v-yingjl's avatar
    v-yingjl
    4 years ago

    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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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/1387187#M626


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

    • MidnaJazz08's avatar
      MidnaJazz08
      Frequent Visitor
      4 years ago

      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's avatar
        v-yingjl
        Icon for Community Support rankCommunity Support
        4 years ago

        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.