Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a situation where there are two table visuals on two different pages and visual level filters are applied on those two visuals.
Now according to the requirement those two visuals needs to be combined in a single table.
For more information on this please have a look at the attached sample pbix file and please suggest some ideas on how can I combine those two visuals in such a way that all the records from those two visuals should show in a single visual.
Solved! Go to Solution.
Hi @Anonymous ,
I would suggest combining the two tables in the below format:
I have created two additional calculated columns
Week Flag = SWITCH(TRUE(),
Table1[Submission Date] >= TODAY()-14 && Table1[Submission Date]<TODAY()-7,1,
Table1[Submission Date]>=TODAY()-7&&Table1[Submission Date]<=TODAY(),2,BLANK())
Week = SWITCH(Table1[Week Flag],1,"Previous 2 Weeks",2,"Last 7 Days",BLANK())And then i have created a matrix which gives the result as shown above.
@jaideepnema - Could you please upload the pbix file over google drive or one drive.
I am not able to replicate the same in matrix.
Hi @Anonymous ,
I would suggest combining the two tables in the below format:
I have created two additional calculated columns
Week Flag = SWITCH(TRUE(),
Table1[Submission Date] >= TODAY()-14 && Table1[Submission Date]<TODAY()-7,1,
Table1[Submission Date]>=TODAY()-7&&Table1[Submission Date]<=TODAY(),2,BLANK())
Week = SWITCH(Table1[Week Flag],1,"Previous 2 Weeks",2,"Last 7 Days",BLANK())And then i have created a matrix which gives the result as shown above.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |