Forum Discussion

gladies123's avatar
gladies123
Helper I
6 years ago

Reg : How to avoid repeated values in matrix visualization

Hi,

 

I attached a image for ur reference , this is the table where i took a fields from different two tables that is table A and Table B. i have created datedim table(date) and have a connection with table A(month start  date) and Table B(revenue date) so in the image

 

practice Group  man month and total cost from table A and revenue amount from table B...........but  i kept revenue amount in values on matrix visualization it does not show  the split belongs to practice group it shows the only total to all fields that is 31,83,98,341 this is not correct..............  but i need  a total which belongs to each practice group.

Need Help

3 Replies

    • gladies123's avatar
      gladies123
      Helper I
      6 years ago

      Hi, Actually Year & Qtr from datedim table and i kept in columns in matrix visualization.  i created a date table and i connected with both tables datedim(date)-table A (month start date),   datedim(date)-table B (revenue date),  practice Group(rows in visualization) it is not  a common field and it' s  from table A 

      • V-lianl-msft's avatar
        V-lianl-msft
        Community Support
        6 years ago

        Hi gladies123 ,

         

        Could you share the sample pbix via cloud service like onedrive for business?

        Please mask any sensitive data before uploading.

         

        Best Regards,
        Liang
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.