empty

5 Topics

Visuals not displaying any data
Hello everyone, I've built a report that is to be used to summarise various economic data. I have been trying to add a slicer into my Power BI report to filter by country across all pages. I had managed to do this, but as soon as I deselected that country and chose another, the visuals wouldn't load. Having deleted the slicer, I cannot revert back either and now all visuals (charts/graphs) that would have been affected by the fitler are now blank. How do I rectify this? - My look clean (None across all pages, 'all' selected on each visual, etc.) - Table mapping of relationships appears correct - Table validation is also okay (e.g. for Italy there is GDP data, it just won't show in the visual) Am I missing something obvious? Thanks in advance!
shaun2421
2 years ago Place Custom Visuals Development Discussion
828Views
0likes
2Comments
EXACTLY what does BLANK() mean in DAX?
I was surprised to see the following expression in Greg Deckler's "Learn Power BI" book: % Utilization = VAR __utilization = DIVIDE([Total Billable Hours], [Total Hours], 0) RETURN __utilization + 0 And my question is about the implications of the last line. Assuming that the VAR expression is returning the same value as BLANK(), then BLANK() is obviously NOT returning a blank character, as adding zero to a character is not meaningful in many computer languages. But Microsoft DOCs only says that BLANK() returns "a blank", which is clearly not true. Apparently BLANK() is a kind of pseudo-NULL, but learning that I can add a number to "nothing" was a surprise. I would appreciate any links or deeper explanations of what's happening above, whether the expression result is equivalent to BLANK() or some other "kind of like NULL" concept. Thanks in advance.
Solved
WayneAtDsn
4 years ago Place DAX Commands and Tips
1.4KViews
0likes
2Comments
Power BI Report Server October 2020 - content vanished completely
Hello Community, we published a report on the Power BI Report Server as usual and after that the report was also available normally. The next day, however, the entire content of the report (all tabs including all visuals) was gone. Also in Power BI Desktop all tabs were gone, only the data modeling was still there. So far, the problem only occurred when using Power BI via a remote desktop, locally the problem has not occurred yet. We are using the Power BI Report Server version October 2020. Is anyone aware of this problem? Kind regards NiHi
Anonymous
5 years ago Place Report Server
716Views
0likes
1Comment
CALCULATE MIN WHEN DATE IS NOT EMPTY
Data has multiple field 1 text values that are duplicated in some cases and field 1 is always populated. Data has multiple field 2 date values that are populated sometimes for field1 when duplicated or not. I figured out how to get the first occurance of the field 2 date for each field 1 when all the Field 1 rows have field 2 dates. What I need to do is not have the MIN(Field2 Date =EMPTY be included in the Calculation when the Fields 2 date for the same field 1 value is populated AND if all the field 2 date values are EMPTY for a given field 1 value to select 1 of the EMPTY field 2 rows Current formula: First_date = VAR _POLDate = CALCULATE ( MIN ( PO_REQ_DISTRIBUTION[PO_LINE_CREATED_DATE]), ALLEXCEPT ( PO_REQ_DISTRIBUTION,PO_REQ_DISTRIBUTION[PO_NUMBER] ) ) RETURN IF(PO_REQ_DISTRIBUTION[PO_LINE_CREATED_DATE] = _POLDate, "1", "0") The issue is it shows the first EMPTY date instead of the populated date:
Solved
Jack2of3
5 years ago Place DAX Commands and Tips
2.4KViews
0likes
3Comments
Card Visual - First, Last, Count (Distinct), Count & "Blank".
Currently the card visual only supports displaying... First Last Count (Distinct) Count and if you want the card to dispaly nothing until filtering is applied, you need a measure and if you have multiple cards, you need multiple measures, all slowing down the report. Can another option be added to the "Card" visual called "Blank" or "Empty", that will display an Card showing no value.
StuartSmith
5 years ago Place Custom Visuals Ideas (read-only)
3.1KViews
0likes
0Comments