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.
Hello,
I have a matrix defined with the following columns as rows.
Options[Category Description],
Options[Option],
Community[_cCommunity with Number],
Options[_cPlan/Elev],
'Option Cost'[Cost Code]
And with the following measure for the value
'Option Cost'[_mOption Cost Code Count Diff]
I want to create a slicer using the 'Option Cost'[_mOption Cost Code Count Diff] measure, in order to filter out rows with values of zero. I have created calculated tables in the past to do this, but not with multiple column/row levels. Unfortunately, I can't make my pbix available.
Looking for any suggestions/advice, thank you in advance.
Could it be this simple?
Here is a link to a simplified pbix version.
https://drive.google.com/file/d/1VJVRq6bPfmauzXdbOVCdVSbUUQD2Lo-t/view?usp=sharing
This screen shot is from the link provided previously.
Below is the calculated table used for the slicer, which has a relationship set with the Option table.
Unfortunately not, the requirement is to be able to toggle on/off including all values or exclude where the 'Option Cost'[_mOption Cost Code Count Diff] measure is zero.
Can you supply a fake set in Excel or something?
Because we cant work with column names only
Maybe I can mock something up in Excel.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |