Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Is there anyway to "Force" the values on the x axis to appear from one (dimension) table, even if there are no values by which to count by for that particular dimension on a fact table?
So say my dimension table has years and quarters historically. And then say my fact table then has a measure for all years/quarters except a few of them. Right now Power BI will automatically remove the year/quarter dimensions for which no row exists in the fact table. Is there a way to show these year/quarters on the x axis with just a zero measure?
Solved! Go to Solution.
Solved my own problem. I turned the original measure into a variable, returned that variable then used IF and ISBLANK functions to test if a value existed, if it didn't, it would return a 0, otherwise it would return the correct measure.
e.g. IF(ISBLANK(SUM(Measure)),0,SUM(Measure))
Solved my own problem. I turned the original measure into a variable, returned that variable then used IF and ISBLANK functions to test if a value existed, if it didn't, it would return a 0, otherwise it would return the correct measure.
e.g. IF(ISBLANK(SUM(Measure)),0,SUM(Measure))
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |