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.
Solved! Go to Solution.
Hi @Anmolgan,
1.Create a slicer table with all the categories in the column:
2.Create a measure as below:
check =
IF(SELECTEDVALUE('Slicer table'[Column1])='ZSD_MAT_MARGIN'[Customer Classification 1],1,0)
3.finally put the measure in the table visual and select measure =1.
For the related .pbix file,pls click here.
Hi @Anmolgan
try a simple column with SWITCH() statement
Customer Classification =
SWITCH(TRUE(),
ZSD_MAT_MARGIN[Volume] >= -1111111 && ZSD_MAT_MARGIN[Volume] <= 20.99, "0-20 KL",
ZSD_MAT_MARGIN[Volume] >= 21 && ZSD_MAT_MARGIN[Volume] <= 49.99, "21-49 KL",
ZSD_MAT_MARGIN[Volume] >= 50 && ZSD_MAT_MARGIN[Volume] <= 99.99, "50-99 KL",
">100 KL"
)
@az38 Hi this is working as required inside the measure, but the problem is this is not working when I take it inside the slider, how can I work this out using the slider option.
That is a custom column that I have calculated, but how can I use the overall built measure inside the powerbi?
@az38 here is the link: https://ifitech-my.sharepoint.com/:u:/g/personal/anmol_ganju_ifi_tech/EUjEXdktSClOrR_MzMAj3rABuCCRWR...
Check the ZSD MAT MARGIN table, measure created is Customer Classification 1 , desired output is been built in the page called "Segment/Sub-Segment Volume/Customer Population" check the table visual there, I just need to add that Customer Classification measure in my slider so thaat I can use the slabs to filter out 0-20 KL etc.
@v-kelly-msft Hi, customer population is a custom column and that is not aligning correctly with the measure that I had built, you can see it for yourself, 0-20 KL slab is not aligning correctly with the custom column filter
Hi @Anmolgan,
1.Create a slicer table with all the categories in the column:
2.Create a measure as below:
check =
IF(SELECTEDVALUE('Slicer table'[Column1])='ZSD_MAT_MARGIN'[Customer Classification 1],1,0)
3.finally put the measure in the table visual and select measure =1.
For the related .pbix file,pls click here.
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |