Forum Discussion
Can we merge two table visuals into one visual having same metrics but different ranking per client?
Hi everyone,
Is there a way we could merge two tables into one table visual? One table showing rank for May month and another showing ranking for June month?
Regards,
Apurva
6 Replies
Anonymous
There is no way to merge visuals. Each individual visual is based on the data table. Generally, you can create 2 measures to rank May and June and put all the field into 1 table visual. But it is hard to say without sample table.You can share a sample pbix with existing data table and the 2 table visuals in the pbix, and also show us your expect output by merging the 2 visuals.
Paul Zheng _ Community Support Team
Best Regards
Hi ,
Please find below inputs and output data for your reference:
Ranking done on basis of Measure column which is IF(Shipped- issue <0,(Order shipped+1.5*Issues)/Oreders Recd,Ratio)
Below is MAY data -
June Data :
Expected Output with June data and additional column reflecting May's Rank:
Can this be achieved reflecting prevous month's rank in current month data