Forum Discussion
Table Visuals Concatenate
Hello power bi supporters,
i have a kind of dilama here and i need your opinions, this is the senario:
i have big table, i put it in table visual to be pivoted, i know i want to do this:
| Level | Product | Value |
| H1 | Owio1 | 100 |
| H1 | Owio2 | 200 |
| H1 | Owio3 | 300 |
| H2 | Poio1 | 100 |
| H2 | Poio3 | 200 |
| H2 | Poio3 | 300 |
| H2 | Poio4 | 400 |
| H2 | Poio5 | 500 |
i have slicer in the page when i choose Level H1
the table will be like that:
| Level | Product | Value |
| H1 | Owio1 | 100 |
| H1 | Owio2 | 200 |
| H1 | Owio3 | 300 |
| Total | 600 |
when i choose Level H2
the table will be
| Level | Product | Value |
| H2 | Poio1 | 100 |
| H2 | Poio3 | 200 |
| H2 | Poio3 | 300 |
| H2 | Poio4 | 400 |
| H2 | Poio5 | 500 |
| Total | 1500 |
so far so fine,
but i know H1 Level always will be less, so i want when i choose Level H1 on slicer:
the table will be :
| Level | Product | Value |
| H1 | Owio1 | 100 |
| H1 | Owio2 | 200 |
| H1 | Owio3 | 300 |
| Diff | Diff | 900 |
| Total | 1500 |
so Diff here is total H2 - Total H1
is there away to do this please?!
Hi Maximous89,
I have reproduced your requirement and successfully implemented the solution. For reference, I have attached the PBIX file so you can review the changes in detail.
Feel free to take a look and let me know if you'd like any adjustments or enhancements happy to help.
Regards,
Harshitha.
7 Replies
Hi Maximous89 - Please find the attached pbix.
Logic and virtual table created as per the above scenerio. please find it.
Hope this helps.
this is good thanks for helping but i want the result table to exactly like this,
Level Product Value H1 Owio1 100 H1 Owio2 200 H1 Owio3 300 Diff Diff 900 Total 1500 Hi Maximous89,
Thank you for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank rajendraongole1 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
As per your requirement I am getting the required solution, but it is coming in a separate column as a different value.Please find the attached screenshot and Pbix for your reference.
Hope this helps if you have any queries we are happy to assist you further.
Best regards,
Community Support Team.
