User Profile
Apple08
Helper IV
Joined 5 years ago
User Widgets
Contributions
Power BI - Smart Narrative
Hi My Power BI Desktop has been updated to the August 2024 version; however, ‘Smart Narrative’ is not showing in the Visualization screen—only ‘Narrative’ is available. I checked the Options > Preview features, but there is no checkbox for ‘Smart Narrative.’ I also searched for ‘Get more visuals,’ but ‘Smart Narrative’ is not available to add. I believed ‘Smart Narrative’ was a default feature in the new version of Power BI Desktop. Could anyone please help me enable ‘Smart Narrative’? Many thanks.Solved4.3KViews0likes6CommentsTo show all legend for a pie chart
Hi All I have a pie chart to show the value of a survey form. Users can select options from a dropdown list. There are five options for users to choose e.g. A,B,C,D,E. Therefore the project field for different months are varied, e.g. Jan-24 with projects A, B, C, Feb-24 with B, C, D, Mar-24 with A,B,C,D,E. I have a pie chart to show the number of projects for different month. Is there a way I can keep the legend always showing a full list of five options in the legend no matter there are no values for the projects. I have tried to right click the field to select 'show items with no data' however it doesn't work. If user select the month Feb-24 the legend still only shows BCD instead of ABCDE. Please could anyone help. Many thanks.Solved1KViews0likes2CommentsRe: To retrieve the latest text by date and time
Sorry, I forgot I also have a column 'Role' in table two and have to filter the role of user in table 2. I have tried to update the code to add in the lookup of 'Assistant' and 'Admin' as below, however it doesn't work. Please are you able to help. Latest Input Value = VAR _max_date_time = MAXX ( FILTER ( 'Table 2', [Name] = EARLIER ( 'Table 1'[Name] ) ), [Date and Time] ) VAR _latest_input = LOOKUPVALUE ( 'Table 2'[Input], 'Table 2'[Name], [Name] && 'Table 2'[Role] in {"Assistant","Admin") 'Table 2'[Date and Time], _max_date_time ) RETURN _latest_input902Views0likes0CommentsTo retrieve the latest text by date and time
Hi All I have two tables as shown below. I would like to lookup the latest input from Table Two and add the latest input into Table One as shown below. Please can anyone help to show me how to do it. Any help is appreciated. Many thanks. Table One Name Latest Input A testing 1 B testing 5 C testing 9 Table Two Name Input Date and time A testing 1 12/09/2023 15:23 A testing 2 23/08/2023 09:30 A testing 3 21/07/2023 12:25 B testing 4 12/08/2023 15:23 B testing 5 12/08/2023 16:30 B testing 6 11/08/2023 15:00 C testing 7 12/09/2023 09:00 C testing 8 23/08/2023 15:00 C testing 9 12/09/2023 16:00 C testing 10 21/07/2023 12:00Solved935Views0likes3Comments- 3.4KViews0likes0Comments
Re: SumX with multiple filters
Thanks sjoerdvn. I did use the filter to filter planned hours to only Red, Green and Amber, however it only works when the planned hours are in it's own Planning table. I need to create a column of planned hours in another table Supplier, so I used the DAX to look for planned hours from Planning table. The DAX is to create a planned hour column in the Supplier table, however once planned hours are shown, they included other categories but not only Red, Green and Amber. Therefore I wonder can I add in more filters into the DAX to get the correct planned hours from Planning table into Supplier table.3.4KViews0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.