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 !
My File :-https://www.dropbox.com/s/5fnohuk5yu88syz/switch%20problem.pbix?dl=0
My numbers are not showing after I am Filtering the slicer.
I want to calculate CTG of Brands (ON/ABOVE) Total Product and Rept NARTD available within Brand Name(brnd_nm) Column. (Refer the Data view)
Now, I want to use the ctgry_nm slicer to see the numbers either by Rept NARTD or Total Product in table 1.
In table 2 and 3 I have edited both the interaction and the numbers are coming.(The numbers are coming correct)
I tried with bookmarks but thats not acceptable by client !😑
Refer the picture !
Thanks in advance !
Solved! Go to Solution.
Hi @souvik900766 ,
A different approach that allows you to use the Category Name to switch between measures:
Hi @souvik900766 ,
A different approach that allows you to use the Category Name to switch between measures:
Hi @souvik900766 ,
In your data, you only have Brand Total Product for the Category Total Product and vice versa. The same happens for Reported NARTD.
Slicing by Category would exclude the rest of the brands.
I believe you want to switch between measures, not categories.
Something like this:
Find the pbix attached.
Let me know if that works for you.
Hi @Payeras_BI ,
Yes you are right I want to switch between measures. That will also work and I am fine with it.
But i cant find the pbix file.
Hi @souvik900766,
Find it attached, mark my previous post as the solution if this helped you.
@Payeras_BI Hi !
I have already tried this technique.
The problem is I have more visuals in the same page with different measures that is only working with the slicer with category from the main table.
Thats why I used this technique of two filters with bookmarks !
Hi @souvik900766 ,
Are all these filters on Brand name meant to be in this visual?
Once removed you get a number.
Hi @Payeras_BI
Yes, they will be thr.Even Total Product and Reptd NARTD will not come. We will use Total Product and Rept NARTD jut to ca;lculate the CTG of Brands and view it with the ctgry_nm slicer.
My final View will be table 2 and 3 !
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |