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.
Hi All
I have a column field , which having value label gtom G1 to G16 , i like to make it only display G2 and G3 only :-
i have try below :-
Below is my PBI sample file :-
Paul
Solved! Go to Solution.
Hi @admin11
you question is already asnsweres as per your ask. please accept that as answer.
However, below is the DAX
GROUP_TYPE_C = IF ( ISBLANK('Group TYPE'[GROUP_TYPE]), "0",if('Group TYPE'[GROUP_TYPE] in {"G2","G3"},"1", "0"))
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi Paul,
Create the slicer then in the Filters, restrict it to show only G2 and G3.
regards
Phil
Proud to be a Super User!
i Have already try using the filter , but some time it work , some time not working. those not working i decide to create slicer to filter.
Paul
Hi Paul,
If you set the filtering as shown I can't think of any reason it shouldn't work. You are saying in the filter only shows G2 and G3. So it should only show G2 and G3.
Can you please link to a file where you've tried the filtering like this and it isn't working.
Thanks
Phil
Proud to be a Super User!
I refer to like below chart , i set at filter only display G1 till G5 and G16.
after i using filter pan to set it , then i create a bookmark = TARGET_SBU , and it work work fine from menu page. directly go to TARGET_SBU.
But then when i go to menu page and go TAGET Tab , and i thru TAGET Tab go to TARGET_SBU Tab , the chart will become un-sort .
@selimovd have show me how to solve this problem different table , by un-tick All visual :-
As not easy to show the actual problem with my actual PBI foc.
Paul Yeo
Hi @admin11
You have displayed group type from table "Group Type" which is union of "sales" and "target_".
Now you have the group_type_c from only "sales" table and sales table doeen't have "G2" or "G3" at all so not able to display these in the slicer.
However if you create the same column on "Group TYPE" table and display it as a slicer you will bve able to see as your requirement.
PFB the file
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Thank you very much it work fine.
Are you able to help me modify the expression , so that it will display 1 or 0 for user to select.
When l Click 1 G2 and G3 will be selected.
Paul Yeo
Hi @admin11
you question is already asnsweres as per your ask. please accept that as answer.
However, below is the DAX
GROUP_TYPE_C = IF ( ISBLANK('Group TYPE'[GROUP_TYPE]), "0",if('Group TYPE'[GROUP_TYPE] in {"G2","G3"},"1", "0"))
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |