Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have Dataset similar to below
cliente_value | Type | Quantity |
0009a4fe-d5ba-e911-a97b-000d3ac1bb7c | EI | 96 |
0009a4fe-d5ba-e911-a97b-000d3ac1bb7c | EFII | 82 |
0009a4fe-d5ba-e911-a97b-000d3ac1bb7c | EFI | 170 |
0008a4fe-d5ba-e911-a97b-000d3ac1bb7c | EFI | 17 |
0008a4fe-d5ba-e911-a97b-000d3ac1bb7c | EI | 3 |
0006a4fe-d5ba-e911-a97b-000d3ac1bb7c | EI | 18 |
0006a4fe-d5ba-e911-a97b-000d3ac1bb7c | EFII | 62 |
0006a4fe-d5ba-e911-a97b-000d3ac1bb7c | EFI | 63 |
0005a4fe-d5ba-e911-a97b-000d3ac1bb7c | EI | 28 |
0003a4fe-d5ba-e911-a97b-000d3ac1bb7c | EI | 23 |
This dataset is connected in a account table with unique values.
I need to create a disconnected table with measure names for Dynamic visual change to show accounts with the client_value type and to show without that type. For example, sometimes I want to see accounts with "EI" and "EFI" type and sometimes I want to see accounts that doesn't have "EI" type.
I tried to create this measure:
this '*Face' table is a non-related table just to create the options to show accounts that I want to see.
I need help, please!
@massotebernoull , not very clear, but check if field parameters can help
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Power BI- Create dynamic slicers using field parameters: https://youtu.be/H2ZxWaHAJZQ
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
Sorry @amitchandak , I’m going to try to enlighten it.
I have ‘accountid’ as dimension table and ‘bz_potencials’ as fact table.
They can connect by accountid = _bz_client_value (but I'm not sure if it will work if I conect these tables).
Accountid has accounts, like this:
Accountid |
0009a4fe |
0008a4fe |
0006a4fe |
0005a4fe |
0003a4fe |
And this is Bz_potencials:
cliente_value | Type | Quantity |
0009a4fe | EI | 96 |
0009a4fe | EFII | 82 |
0009a4fe | EFI | 170 |
0008a4fe | EFI | 17 |
0008a4fe | EI | 3 |
0006a4fe | EI | 18 |
0006a4fe | EFII | 62 |
0006a4fe | EFI | 63 |
0005a4fe | EI | 28 |
0003a4fe | EI | 23 |
I need to create a slicer that gives me do two kind of analysis:
The first one is to see accounts that have some specific type, like EI, EFI or EFII.
The other analysis, is to see accounts that doesn’t have that king of type (accounts that doesn’t have EI, for example).
The measure I’m failing to create, also is not giving me any information when I try to filter more than one option, like EI and EFI.
I really appreciate your help, thank you!
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |