Is 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!
Add 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.
Dynamic 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!
Power 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!
Power 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!
Issue 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 advance
ArcGIS for PBI-Tooltips
I'm using ArcGIS in a station pump read dashboard where I've overlayed rainfall data to find (if any) impacts of rainfall on our utilities system. Using the ArcGIS visual, which maps the stations throughout the city using symbols and colors to indicate which stations were impacted most during median high rain runtime and the relative rain response. The problem: the measures I'm using in the visual are represented with size and color on the map BUT when I put them in the Tooltips area, only one shows up, "Median high rain runtime per day". So I created a report page for tooltip and only 3 of 5 measures show up, one of them being "Median high rain runtime per day". This is what it looks like when I hover over a point on the map. My measures are: Median high rain runtime per day (show in report page tooltip) Median low rain runtime per day High rain period count (show in report page tooltip) Low rain period count (show in report page tooltip) Rain response % These measures work in other visuals and in a simple table. This is what the Report tooltip page looks like with all of them displayed: Here's the DAX for the above measures: Median Low-rain runtime per day = //This calculates the median combined runtime of all pumps at the station during low-rain periods. VAR StationPeriods = CALCULATETABLE( VALUES( 'Pump Readings'[Scatter Station Period ID] ), REMOVEFILTERS('Pump Readings'[Date]) ) VAR LowRainPeriods = FILTER( StationPeriods, VAR PeriodRainfall = CALCULATE( MAX( 'Pump Readings'[Rainfall During Reading Period] ) ) RETURN NOT ISBLANK(PeriodRainfall) && PeriodRainfall <= 0.25 ) RETURN MEDIANX( LowRainPeriods, CALCULATE( SUM( 'Pump Readings'[Runtime Hours Per Day] ) ) ) Median High-Rain runtime per Day = //This calculates the median combined runtime of all pumps at the station during high-rain periods. VAR StationPeriods = CALCULATETABLE(VALUES('Pump Readings'[Scatter Station Period ID]), REMOVEFILTERS('Pump Readings'[Date]) ) VAR HighRainPeriods = FILTER( StationPeriods, CALCULATE( MAX( 'Pump Readings'[Rainfall During Reading Period] ) ) >= 0.75 ) RETURN MEDIANX( HighRainPeriods, CALCULATE( SUM('Pump Readings'[Runtime Hours Per Day]) ) ) Median High-Rain runtime per Day = //This calculates the median combined runtime of all pumps at the station during high-rain periods. VAR StationPeriods = CALCULATETABLE(VALUES('Pump Readings'[Scatter Station Period ID]), REMOVEFILTERS('Pump Readings'[Date]) ) VAR HighRainPeriods = FILTER( StationPeriods, CALCULATE( MAX( 'Pump Readings'[Rainfall During Reading Period] ) ) >= 0.75 ) RETURN MEDIANX( HighRainPeriods, CALCULATE( SUM('Pump Readings'[Runtime Hours Per Day]) ) ) Low-Rain Period Count = //Create counts so one or two periods do not drive the result. VAR StationPeriods = CALCULATETABLE( VALUES('Pump Readings'[Scatter Station Period ID]), REMOVEFILTERS('Pump Readings'[Date]) ) RETURN COUNTROWS( FILTER( StationPeriods, CALCULATE( MAX( 'Pump Readings'[Rainfall During Reading Period] ) ) <= 0.25 ) ) Rain Response % = //Interpretation: 0%: no observable difference,25%: median runtime is 25% higher during high-rain periods, 100%: median runtime doubles, Negative value: runtime was lower during the high-rain periods VAR LowRainRuntime = [Median Low-rain runtime per day] VAR HighRainRuntime = [Median High-Rain runtime per Day] RETURN IF( ISBLANK(LowRainRuntime) || ISBLANK(HighRainRuntime) || LowRainRuntime = 0, BLANK(), DIVIDE( HighRainRuntime - LowRainRuntime, LowRainRuntime ) ) I've been troubleshooting this for about two days now and can't seem to find the solution. I've even rewritten the two measures that are not showing up. Any help is appreciated.
How to calculate Route based on repeating cycle
HI, I have this table A: Here you can see id has different route. So, when route is not repeating than good path and if route is going back to any previous route, then its bad path. Like image below How to achieve final visuals like image below? Thanks
