Dynamic Slicer – Show Fiscal Year for INR Country and Calendar Year for Others
Hi Experts, I have a requirement to dynamically customize my date slicer based on country selection. Scenario: If the user selects INR (India) as the Country → The slicer should display Fiscal Year (Apr–Mar). If the user selects any other country → The slicer should display Normal Calendar Year (Jan–Dec).Need Urgent Help on SamePeriodLastYear
Dear Pros, Can you please help me to calculate the below? I have the sales data of 2024 & 2025 in the same table. 1. I want to calculate the difference between 2025 month on month data and 2024 month on month. 2. I want to calcuate the % differece between 2025 month on month data and 2024 month on month. I also have the categories and subcategories, I want difference based on these level as well. I want to show the result in a clustered column char Thanks
On Jira find the Timestamp when status changed
I am connecting Jira data with Power BI. I need to find the lifecycle of a issue in each status forexample when issue 123 changes state from status A to status B. I need to calculate the time in number of days like Today()- timestamp when it moved from previous state There is no clear way on it to find the that field. I was thinking if anyone has worked with jira logs how to connect jira logs with the Power Bi because in activity we can see the date. Any help would be a great help Thanks in advance
Doing a rank with a column created in variable
Hi everyone, I need to rank the Sales of the Employees, but I have a table and a new column called Test created as a variable in th DAX. This is to improve the performance. I have tried it without and it is taking too long to load, so this is my only solution. The loading time is no problem anymore but now I dont know how to iterate through the new column Test to get the ranking right. I need to use that column (which is a replication of the column Sales) because the column Sales is based on a lot of measures, which is the reason why it takes so long to load. The query is executing but the rankings come out all as 1. It must be due to the SUMX() that just compares every row with itself. How can I fix this? Your help is gretaly apreciated. Measure = VAR table_ = ADDCOLUMNS ( SUMMARIZE ( 'TableEmployee', 'TableEmployee'[Employee], "Sales", 'TableSales'[Sales] ), "Test", [Sales] ) RETURN RANKX( ALLSELECTED( 'TableEmployee'[Employee] ) , ( SUMX(table_, [Test])),,ASC,Dense)
Default Sorting implementation: custom visual
Hello Developers! I hope you all are doing well. The issue iam facing right now is adding sorting options in my custom visual. My X and Y axis are categorical axis but when i use the default sorting method by following: https://learn.microsoft.com/en-us/power-bi/developer/visuals/sort-options , sorting option is available for only the x axis and measure. However, I want the sorting option for Y axis as well. How can i achive this? I have just used "sorting": {"default": {} } in my capabilities. Thank You in advance! Regards, AakashColumns With Multiple Data Types in Power BI
Hello, Currently within my dataset there is a column that contains numerical, text, percentage and currency data types. Is it possible to show them in the same datatype while we select? The table when loaded it saves it by default as text which is understandable. For example: Value 89 150 103 150 $ 1,548,550.45 $ 2,909,454.99 Phase 0 Phase 0 Phase 0 Phase 0 94% 101% 95% 99% Excel and Power BI difference. Thanks for hellping in Advance Ayush
