The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
HI,
When I add my measure for some strange reason rows just disappear. How do I avoid this from happening?. I even included an index column to avoide this from happening.
Please find a link to the dataset that I am working with:
https://www.mediafire.com/file/f4tyos1nq8sgvtx/Sample_Statement.pbix/file
Thank you,
Solved! Go to Solution.
The index doesn't matter. Powre BI only shows dimensions when there is also data (not when you just drop in a dim field and nothing else, but as soon as you drop in a measure, it filters the DIM field.)
So you'd have to create a measure that returned either 0 or a non-blank, so space or dash.
In a Table visual, you can tell it to show items with no data. Right-click on the dimension in the field pane:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingBecause the measures are returning blank, so data will not show up. So go into your measure and wrap it with COALESCE.
So SUM(Table[SomeColumn]) becomes COALESCE(SUM(Table[SomeColumn]), 0)
So if it returns blank, it will show 0, not nothing.
I didn't download your file because it is asking for eleventy three cookies and some agreement and I closed it. If my answer above isn't correct, please reshare with OneDrive or Dropbox, or maybe someone else will agree to everything that site wants to put on their computer.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you for your reply. Although, I'd like the rows to show blank if there isn't a value there. Please see an image of what the table looks like before the measure is added:
As soon as I enter it this happens:
I was hoping that adding the indexes would prevent this. The index and the attribute are both set to 'don't summarize'.
I was actually implementing the same method I had learnt from an online course. The teacher used the following code:
On my visual, If I change the attribute from 'don't summarize' to 'first' it shows some of the empty rows but not all of them:
Do you have any idea on what I'm doing wrong here?
The index doesn't matter. Powre BI only shows dimensions when there is also data (not when you just drop in a dim field and nothing else, but as soon as you drop in a measure, it filters the DIM field.)
So you'd have to create a measure that returned either 0 or a non-blank, so space or dash.
In a Table visual, you can tell it to show items with no data. Right-click on the dimension in the field pane:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingNice. The 'show items with no data' worked as it should. Thank you.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
42 | |
24 | |
23 | |
14 |