Forum Discussion

gladies123's avatar
gladies123
Icon for Helper I rankHelper 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 w...
Need Help
gladies123's avatar
gladies123
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity 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.