tooltip
15 TopicsGo to the Dash board sheets
Hello, I have a chalange that I can not pass from one KPI card which is on one sheet to the other sheet and be able to see only what is wrong on that KPI card. I can make that through navigation page to the to sheet from the KPI but the table which I wont to be filtered automaticaly in second sheet doesnt work. Can some one have a solution for this Power Bi Microsoft Thank you in advance70Views2likes6CommentsTurn off UI tooltips
Those of you who work in Power BI Desktop every day, I hereby rally you. We must be unified in our protest, posting together with one voice: PLEASE LET US DISABLE UI TOOLTIPS!!!! Anyone with me? I know this can be done. Like, in a day. The Microsoft Team can provide a toggle in Options for us to turn off these pesky little flies that add precious minutes of work to our days EVERY day. We cannot go as fast as we want to go with these hover pop-ups getting in the way on every section of the UI. Please Microsoft. Adding this option would endear us to you for all eternity. (And if any of you know some hidden way to turn them off, do share!) (And if I'm in the wrong place and I should add this to an idea board somewhere that I can't seem to locate, please share that link!)77Views1like5CommentsIs It Possible to Create a Qlik Sense-Style Date Picker in Power BI Without Using Paid Visuals?
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Hello everyone, I've been trying for quite some time to build a date picker in Power BI similar to the one available in Qlik Sense, but so far I haven't been able to find a solution that fully replicates that behavior. What I'm looking for is a date picker that allows users to: Select a start date and an end date from a visual calendar. Manually select a date range by clicking on the desired dates. Optionally display predefined quick ranges such as: Today Yesterday Last 7 Days Last 30 Days This Month Last Month Work similarly to the date picker available in Qlik Sense or in many modern web applications. I have already explored several alternatives: The native Power BI date slicer (Between). Bookmarks. Custom period tables. Custom visuals available in AppSource. However, none of these options seem to provide the same user experience without relying on paid visuals. My question is: Do you know of any way to achieve something very similar using only standard Power BI functionality or a free solution? Any experience, examples, suggestions, or ideas for further investigation would be greatly appreciated. Thank you very much!64Views0likes5CommentsAdvance Editor Looks Different
Please see below 2 screenshots of when i click on advance editor in PowerBI. The first screenshot is what i used to get and the one with purple cube is what i am getting now. do you know why i am getting purple cube view now? How do i go back to older version?Solved106Views2likes5CommentsAdd Tenant/Environment Selection in Power BI Desktop
Seria extremamente útil adicionar um Seletor de Locatário/Ambiente diretamente no Power BI Desktop para usuários que têm acesso a vários ambientes do Microsoft Fabric/Power BI usando a mesma conta. Atualmente, o Power BI Desktop não oferece uma opção clara para alternar entre os tenants disponíveis após o login. Os usuários podem precisar sair, fechar o aplicativo e entrar novamente, o que torna o processo inconveniente e pode causar confusão ao trabalhar com diferentes ambientes. Uma opção dedicada "Alternar ambiente" ou "Alternar locatário" no menu da conta facilitaria o processo: Alterne rapidamente entre os ambientes disponíveis. Evite sair e entrar repetidamente na sua conta. Reduzir o risco de trabalhar com o inquilino errado. Melhorar a experiência dos usuários que trabalham em ambientes de desenvolvimento, teste e produção. Tornar o gerenciamento de ambientes mais consistente com a experiência web do Power BI/Fabric. Essa funcionalidade seria especialmente valiosa para organizações onde a mesma conta de usuário tem acesso a vários tenants do Power BI/Fabric.Solved94Views0likes4CommentsDynamic axis label: show real name only for one company, others "Anonymous"
I have a bar chart (ranking) with one bar per company. All companies should stay visible, but the labels on the axis should work like this: The company of the current user (identified via USERPRINCIPALNAME() and a mapping table Company ↔ E-Mail) shows its real name All other companies show as "Anonymous" (or a neutral label) Example: Bar Label for user of Company 12 1 Anonymous 2 Anonymous 3 Company 12 4 Anonymous The problem: An axis field must be a column, but the logic depends on the current user, so I can only build it as a measure: DAX Firma Anzeige = VAR _Own = [Eigene Firma] // LOOKUPVALUE on the mapping table via USERPRINCIPALNAME() VAR _Current = SELECTEDVALUE( Fakten[Firma] ) RETURN IF( _Current = _Own, _Current, "Anonymous" ) A calculated column doesn't work either, because it is only calculated at refresh time and not per user. My current workaround: I show an index/letter on the axis and a separate small table that maps the letter to the user's company. My client finds this too complicated. Question: Is there any way to show a user-dependent label (real name vs. "Anonymous") directly on the axis of a bar chart? For example with field parameters, dynamic format strings, visual calculations, or a different table design? Or is there a better pattern for this scenario? Thanks in advance!Solved77Views4likes7CommentsPower BI Field Parameters with Paginated Reports – Looking for Guidance
Power BI Field Parameters with Paginated Reports – Looking for Guidance Hi everyone, I am trying to understand the best approach for using Power BI Field Parameters with Paginated Reports. I understand that Power BI Field Parameters allow users to dynamically switch between fields or measures in a Power BI report. My question is whether similar functionality can be achieved when working with Paginated Reports. For example, I am looking for something like: Power BI Report → Field Parameter → Paginated Report → Dynamically change the field/column displayed or used by the Paginated Report Specifically: Can a Power BI Field Parameter be passed to a Paginated Report? Can a Paginated Report consume a Power BI Field Parameter directly? Can a Field Parameter be used to dynamically determine which column/field is used in a Paginated Report query? If Power BI Field Parameters are not supported for this scenario, is there an equivalent out-of-the-box feature in Power BI Report Builder / Paginated Reports? Can this be achieved using standard Paginated Report Parameters, expressions, or dynamic query logic? Is the Paginated Report visual in Power BI the recommended way to achieve this type of interaction? For example, the desired experience would be: User selects: Customer Name OR Product Name OR Supplier Name and the Paginated Report dynamically uses the selected field/column. I understand that Power BI Field Parameters and Paginated Report Parameters are different concepts, so I am specifically trying to understand whether there is a supported way to achieve the same dynamic field-selection experience in Paginated Reports. If anyone has implemented this scenario, I would appreciate guidance on the supported approach and any limitations. Thanks!Solved85Views1like4CommentsPower BI Sentence Template Tooltip – How to Display Measure Values on Separate Rows?
Hi Everyone, I am trying to replicate the default Power BI tooltip using the Sentence Template tooltip because of a business requirement. I have created a DAX measure that performs the required calculations and concatenates multiple values into a single text output. I am trying to use UNICHAR(10) to display each value on a separate line/row. However, UNICHAR(10) does not appear to create a line break when the measure is displayed in the Sentence Template tooltip. All the values are displayed on the same line. Example I have a measure similar to the following: Tooltip Text = "Sales: " & FORMAT([Sales], "#,##0") & UNICHAR(10) & "Profit: " & FORMAT([Profit], "#,##0") & UNICHAR(10) & "Margin: " & FORMAT([Margin], "0.0%") I would like the tooltip to display something like: Sales: 1,250,000 Profit: 350,000 Margin: 28.0% Instead, the Sentence Template tooltip displays it approximately like this: Sales: 1,250,000 Profit: 350,000 Margin: 28.0% What I am looking for Is there any way to create line breaks / separate rows within a Sentence Template tooltip using a DAX measure? More specifically: Does Sentence Template support UNICHAR(10) or any other Unicode character for line breaks? Is there another DAX approach that can force the concatenated measure values onto separate rows? Is it possible to replicate the default Power BI tooltip layout using Sentence Template while keeping the values dynamically calculated? If Sentence Template does not support this, is there any workaround that allows us to achieve the same result without creating a separate tooltip page? Any guidance or alternative approach would be greatly appreciated. Thanks in advance!Solved107Views0likes3CommentsIssue with table visual on Power BI Desktop
I am having an issue with Power BI Desktop table visualization. This problem started last week and i did not face this issue during August 2026. The visual shows how clean the data looks which is from August 2026 on the left but the one I have is from September 2026 and the table visual looks super weird which is on the right. I want to fix my table visual so it looks like the one on left! Most of my visuals have been acting stramge as well Really need help as I need to create a report which is due by wednesday! thank you in advanceSolved137Views1like6CommentsEnquiry about year to year % measurement
I have a date dimension table and 2 tables Fact tables. The fact tables are cases and breaches. the relationship is one case to many breaches. One date can have many cases. I would like to calculate the YTD and Previous YTD count of cases and % change for year, quarter for last few years. How can I do that? someone has provided some dax. My current formula is 1. YTD Incidents = CALCULATE([Number of cases],DATESYTD('Cases'[Lodged Date].[Date])) 2. PYTD Serious Incidents = CALCULATE( [YTD Incidents], SAMEPERIODLASTYEAR(' Cases'[Lodged Date].[Date])) 3. YonY_Cases_%_Change = VAR CurrentRate = [YTD Incidents] VAR PriorRate = [PYTD Incidents] VAR PctChange = DIVIDE(CurrentRate - PriorRate, PriorRate, 0) VAR Arrow = IF(PctChange > 0, "▲ ", IF(PctChange < 0, "▼ ", "")) RETURN Arrow & FORMAT(PctChange, "0.0%") Someone has provided me the following DAX. how can i use that to generate YtoY % change, YTD vs PTD % change, quarter to quarter % change? thanks. VAR SelectedYear = SELECTEDVALUE('dimDate'[Year]) VAR MaxDataDate = [Latest Data Date] VAR StartDate = DATE(SelectedYear, 1, 1) VAR EndDate = IF( SelectedYear = YEAR(MaxDataDate), MaxDataDate, DATE(SelectedYear, 12, 31) ) And used StartDate and EndDate to filter Similarly, for previousYear: VAR SelectedYear = SELECTEDVALUE('dimDate'[Year]) VAR MaxDataDate = [Latest Data Date] VAR StartDate = DATE(SelectedYear - 1, 1, 1) VAR EndDate = IF( SelectedYear = YEAR(MaxDataDate), DATE( SelectedYear - 1, MONTH(MaxDataDate), DAY(MaxDataDate) ), DATE(SelectedYear - 1, 12, 31) )Solved123Views2likes7Comments