The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
This is my requirement: I have a sales volumes table; there is a row for each sale a store made, for each day of the year.
Each row is marked with a flag Comparable - 1 means "Comparable", 0 means "Not Comparable".
The user wants the ability to see all data or Comparable data only.
I can put a slicer that filters against the "Comparable " dimension, but it will show "Comparable" and "Not Comparable" choices; I can activate the "Select all" option. Unfortunately the user does not want the ability to filter for "Not Comparable" data only, because - being not comparable - by definition that data alone is meaningless. He only wants the ability to see all data (comparable and not comparable altoghether) or Comparable ones only. Something like this:
Anyone has a suggestion on how to achieve this? I attach some sample data
Note that in the sample report the "ALL" choice fiters for non comparable data, which is *NOT* the desired behaviour.
Thanks in advance,
Gianfranco
EDIT: Sorry, I can't figure out how to attach the sample PBIX file, someone can teach me? Thank you
Solved! Go to Solution.
One approach is to use a field parameter. First create the two measures below, and then create a field parameter using these measures.
All = SUM ( Sales[Amount] )
Comparable only = CALCULATE ( [All], Sales[Comparable] = 1 )
Field parameter (created via the user interface as explained in the article below):
Parameter = {
("All", NAMEOF('Measure'[All]), 0),
("Comparable only", NAMEOF('Measure'[Comparable only]), 1)
}
Use 'Parameter'[Parameter] in a visual:
-----
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Proud to be a Super User!
IT WORKS! Thank you very much!
One approach is to use a field parameter. First create the two measures below, and then create a field parameter using these measures.
All = SUM ( Sales[Amount] )
Comparable only = CALCULATE ( [All], Sales[Comparable] = 1 )
Field parameter (created via the user interface as explained in the article below):
Parameter = {
("All", NAMEOF('Measure'[All]), 0),
("Comparable only", NAMEOF('Measure'[Comparable only]), 1)
}
Use 'Parameter'[Parameter] in a visual:
-----
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Proud to be a Super User!
User | Count |
---|---|
65 | |
62 | |
60 | |
53 | |
28 |
User | Count |
---|---|
181 | |
82 | |
67 | |
47 | |
44 |