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 acolumn of data for stock demand whcih either has many number vlaues or blank cells.
I want to include a clicer in the report with just two options for either demand yes or no.
So basically where there is a blank it will be demand no and any number will be demand yes.
Can you please point me in the right direct how to set this up? Thanks Andy
Solved! Go to Solution.
You can create a new Column with a Dax formula like this.
Hello @AMaxfield,
You can create a calculated column as below:
Demand Yes/No = IF(ISBLANK(Table[Stock Demand]),"No","Yes")
You can use this column in the slicer.
Great thanks worked once I realised it was "New Column" rather than "New Measure"
Hello @AMaxfield,
You can create a calculated column as below:
Demand Yes/No = IF(ISBLANK(Table[Stock Demand]),"No","Yes")
You can use this column in the slicer.
You can create a new Column with a Dax formula like this.
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 |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |