Forum Discussion
amirghaderi
Helper IV
Helper IVGroup by slicer
I am trying to have an option for Power Bi readers to be able to select the grouping of data in table/matrix visual. For example, in the below table, I want to have a slicer which allows to see the ...
amirghaderiHelper IV
Helper IVThanks, this soloution works to an extend. i have faced another issue now.
If there is a record which does not have group1/2 code not assigned, i want to be shown in the report as a blank grouping. For record F in the below screen, it should be shown in the visual with blank group. Any idea how to fix it?
| Item | Group1 | Group2 | Price |
| A | AA | LL | 200 |
| B | AA | GG | 300 |
| C | BB | EE | 400 |
| D | CC | EE | 100 |
| E | DD | EE | 200 |
| F | 50 |