List of values with filter, kindly help me!
Hi Team, Kindly help me for filter visual. I have the 'Data' column and categories columns. like below snapshot format. we required filter, If I select categories col of 'a' then "a" related all data shown like below snapshot. If select 'b' then "b" related of all data required. How to it in DAX with this? Note:- In power query it is possible, by splitting muliple cols and we will do it. but have performacne impact, kindly help me to it using DAX?
Filtering a table using TOP N slicer
Hi, i have a TOP N slicer which is a what if parameter from 0 to 50, i am trying to filter TOP N qty for a product in a table. please note there is already a TOPN filter on week for the table visual like pic below, so another topn is not possible and the data does not have an id/unique column and the products are repeted several times and the week in the sample is different from the topn loaddateweek. I am using a DAX measure to calculate the top products TOP N measure = VAR SelectedTop = SELECTEDVALUE('TOPN'[TOPN]) RETURN SWITCH(TRUE(), SelectedTop = 0, [Still to supply_sum], RANKX( ALLSELECTED(table[week],table[Product]), [Still to supply_sum], ,DESC,Dense ) <= SelectedTop, [Still to supply_sum] ) but this is not filtering for only 1 value when top n filter selected =1, but shows multiple value. Sample data is like below: Week Product Still to supply_sum rank 2024 34 6708 58720 1 2024 40 7706 64919 1 2024 38 6708 48120 2 2024 40 6708 43040 2 2024 38 731 34400 3 2024 36 6708 33560 3 2024 39 7448 36000 3 2024 41 6961 32040 5 2024 38 300 30080 6 2024 36 300 28120 7 2024 30 7551 24720 9 2024 41 122116010 22160 10 2024 36 731 21560 11 2024 41 7551 19790 15 2024 32 7551 19168 17 2024 31 300 16204 24 2024 32 300 15669 25 Not sure how to solve this issue to just have rank that does not repeat for a another row for the same product. Thanks for the help in advance.DAX query required for IF and IF Else condition of below case
Hi Team, I am new to PBI, help me with this case! IF type(col) = "AAA" & Date time(col) < 11AM then Pickup date = Date(col)-1 ELSE Pickup date = Date(col) IF type(col) = "BBB" then Pickup date = Date(col)–1 IF type(col) = "CCC" then Pickup date = Date(col) Value of "AAA" is having AAA_a, AAA_b, AAA_c, AAA_d, AAA_e ----AAA_n etc. So here we are calling the condition with "AAA". How do we calling "AAA" with one IF condition statement or any other. Same like value of "BBB" & Value of "CCC". Here date time(col) contains 24hrs, we required less than(< )upto 11AM then Pickup date = Date(col)-1, else Pickup date = Date(col). Here Date(col) is calculated column. So, kindly helpe me with the DAX query. below is the snapshot for your reference.
Printing content of web link in power bi table [ column] in one go
I have use case , A table has column mnamed LINK. it hold https link to a pdf content. there will be more rows in table with link as column. I am trying find solution to have button [ one click] does below. 1. Iterates all the links in LINK column 2. hit the link and get the PDF content one by one 3. Send the pdf to printer. How can i achieve this ?Visuals loading Error
Hello everyone, For one of my work reports I got the error of visuals loading.I waited around 30 minutes but it still doesn't show the visuals on the report.When ı put my mous click on loading icon it says that visuals are loading.How can I solve this? As you can see in the picture the bar graph can not load.calculate time spent in each state
i have a data as given below Ticket num Created state Ticket_1 11/3/2022 0:06 P4 Ticket_1 11/3/2022 0:18 P4 Ticket_1 11/3/2022 0:21 P3 Ticket_1 11/3/2022 0:22 P2 Ticket_1 11/3/2022 0:23 P1 Ticket_1 11/3/2022 0:24 P1 Ticket_1 11/3/2022 0:26 P1 Ticket_2 12/12/2022 13:40 P1 Ticket_2 12/12/2022 13:41 P1 Ticket_2 12/12/2022 13:43 P2 Ticket_2 12/12/2022 13:45 P2 Ticket_2 12/12/2022 13:45 P4 Ticket_2 12/12/2022 13:46 P3 Ticket_2 12/13/2022 14:00 P1 i would now like to calculate time spent by each state in hours/seconds for every ticket in a 100% stacked bar chart and see the transition for state for Ticket_1 which changes from P4-->P3-->P2-->P1 Final chart to look something like this
Custom Comparison Filter
I want to create a way a user can select a drop down and you can compare the data based on current date range against what is selected. Similar to Google Data Studio. You can select to compare current date range vs. last period, last year or a custom date range you select. I feel like this is possible, using parameters but unsure. I would want to this with rates or calculated measures like CPM, CTR, CPC etc
achieving previous FY + 3 months of current FY in DAX
Hi friends, I need a DAX formula for my Custom Financial year. I would like to add a column showing: my financial year is 1st July 2022 - 30th June 2023 and dax formula should display: 1) if today's date is October or greater then show TRUE for dates falling within current financial year. 2) However, if today's date has recently entered a new financial period and current date falls within July, August, september (ie first 3 months of FY Period) then TRUE should display for dates falling within previous FY and up to dates within July, Aug, Sep of current financial year period. otherwise, false if neither of these conditions are met. Expected results if current month is August: FY Year Month Month Number Desired Result 2023/2024 2023 august 8 TRUE 2023/2024 2023 july 7 TRUE 2022/2023 2022 june 6 TRUE 2022/2023 2022 may 5 TRUE 2022/2023 2022 april 4 TRUE 2022/2023 2022 march 3 TRUE 2022/2023 2022 february 2 TRUE 2022/2023 2022 january 1 TRUE 2022/2023 2022 december 12 TRUE 2022/2023 2022 november 11 TRUE 2022/2023 2022 october 10 TRUE 2022/2023 2022 september 9 TRUE 2022/2023 2022 august 8 TRUE 2022/2023 2022 july 7 TRUE 2021/2022 2022 june 6 FALSE 2021/2022 2022 may 5 FALSE 2021/2022 2022 april 4 FALSE 2021/2022 2022 march 3 FALSE 2021/2022 2022 february 2 FALSE 2021/2022 2022 january 1 FALSE Expected results if current month is November: FY Year Month Month Number Desired Result 2023/2024 2023 november 11 TRUE 2023/2024 2023 october 10 TRUE 2023/2024 2023 september 9 TRUE 2023/2024 2023 august 8 TRUE 2023/2024 2023 july 7 TRUE 2022/2023 2022 june 6 FALSE 2022/2023 2022 may 5 FALSE 2022/2023 2022 april 4 FALSE 2022/2023 2022 march 3 FALSE 2022/2023 2022 february 2 FALSE 2022/2023 2022 january 1 FALSE 2022/2023 2022 december 12 FALSE 2022/2023 2022 november 11 FALSE 2022/2023 2022 october 10 FALSE 2022/2023 2022 september 9 FALSE 2022/2023 2022 august 8 FALSE 2022/2023 2022 july 7 FALSE 2021/2022 2022 june 6 FALSE 2021/2022 2022 may 5 FALSE 2021/2022 2022 april 4 FALSE 2021/2022 2022 march 3 FALSE 2021/2022 2022 february 2 FALSE 2021/2022 2022 january 1 FALSE Current script: Central_Calendar = ADDCOLUMNS( CALENDAR(DATE(2022,1, 1), DATE(2030,1,1)) , "Year", YEAR([DATE]) , "MonthNumber", MONTH([DATE]) , "Month", FORMAT([DATE], "MMM") , "Quarter", "Q " & FORMAT([DATE], "Q") , "QuarterNumber", FORMAT([DATE], "Q") , "Year Quarter", YEAR([Date]) & " " & "Q" & QUARTER([Date]) , "Year Quarter Sort", YEAR([Date]) & QUARTER([Date]) , "YearMonthNumber", FORMAT([DATE], "yyyy-mm") , "Month Year", FORMAT([DATE], "MMM YY") , "Month Year Sort", YEAR([Date]) *100 + MONTH([Date]) , "Fiscal Year", YEAR(EDATE([DATE], 6)) , "FY", "FY" & IF(MONTH([Date])<7, YEAR([Date])-1 & "/" & FORMAT([Date], "YY"), YEAR([Date]) & "/" & FORMAT(EOMONTH([DATE], 6), "YY")) , "Fiscal Month", MONTH(EDATE([DATE], 6)) , "Fiscal Quarter", QUARTER(EDATE([DATE], 6)) , "Fiscal Week", WEEKNUM(EDATE([DATE], 6)) , "Last 6 Months", IF(EOMONTH([DATE], 0) > EOMONTH(TODAY(), -6) && [date] <= TODAY(), TRUE()) , "Current_FY_to_Date", IF([DATE] >= DATE(YEAR(TODAY()) -1, 7, 1) && [DATE] <= TODAY(),TRUE(), FALSE()) , "Previous_FY", IF([DATE] >= DATE(YEAR(TODAY()) -2, 7,1) && [DATE] <= DATE(YEAR(TODAY()) -1, 6, 30),TRUE(), FALSE()) , "Previous_FY_Month", IF([Date] >= EDATE(TODAY(), -1) && [Date] <= EOMONTH(TODAY(), -1) && [DATE] >= DATE(YEAR(TODAY()) -1, 7,1), TRUE(), FALSE()) , "Previous_Month", IF([Date] >= EDATE(TODAY(), -1) && [Date] <= EOMONTH(TODAY(), -1), TRUE(), FALSE()) , "Current_FY_or Prev_FY_plus 2 months of current FY", IF ( AND( TODAY() >= DATE(YEAR(TODAY()), 7, 1), // Check if today's date is between July 1 of the current fiscal year TODAY() <= DATE(YEAR(TODAY()), 9, 30) // and September 30 of the current fiscal year ), OR( YEAR(EDATE([DATE], 6)) = YEAR(TODAY()) - 1, // Return TRUE for dates of the previous fiscal year [DATE] = DATE(YEAR(TODAY()), 9, 30) // Return TRUE for September 30 of the current fiscal year ), IF ( AND( TODAY() >= DATE(YEAR(TODAY()), 10, 1), // Check if today's date is between October 1 of the current fiscal year TODAY() <= DATE(YEAR(TODAY()) + 1, 6, 30) // and June 30 of the next fiscal year ), IF ( [DATE] >= DATE(YEAR(TODAY()) , 7, 1) && [DATE] <= TODAY() // Return TRUE for dates of the previous fiscal year to date TRUE(), FALSE() ), FALSE // Return FALSE if neither condition is met ) )) any suggestions on how to achieve this would be appreciated.
How to publish Power BI report to Power BI Report Server
Hi Everyone, What I wanted to know is how can I publish report on Power BI Report Server as shown below: But since I am using Power BI Desktop version - 2.121.762.0 64-bit (September 2023) I am unable to save nor share report to Power BI report Server. Furthermore, I tried to use Power BI Desktop version 2.117.984.0 64-bit (May 2023) but since it does not support some of the preview features such as shape map etc that are required for my project I am not able to solve this by switching to that version. Are there any workarounds that I could implement using Power BI Desktop version - 2.121.762.0 64-bit (September 2023) ? or do I have to use different Power BI Desktop version with different workaround? If anyone can help me with this it would be much appreciated.
