Help!! Multiple Tooltips are not working properly!
Hi everyone, I'm newish to BI and am trying to assign a tool tip to only 2 columns in a Matrix, what I would like is to have one tooltip when hovering over a cell in the "Criteria" column, no tooltip on "Units", "ActVal", "ForVal" and then a different tooltip assigned to "Forecast Accuracy" I've managed to get 2 different tooltips applied but when I set one up for the Criteria column, it doesn't work. That tooltip works when I hover over the next 3 columns and then the 2nd tooltip populates on the last column correctly. Is it possible to assign a tooltip to the "Row" data in the Matrix, or even to have columns within the matrix that don't have a tooltip? Sample BI Project
Generating reports in PowerBI Report Server from Java based application
Hello guys, I am new to PowerBI and our requirement is to generate reports leveraging PowerBI (i.e generating report [PDF] as per template provided once a user clicks on button in JSP of web-based java application). In order to fulfill above what is the best possible way to connect to Report Server from on-prem java based application and provide inputs or data to generate the report in UI. Currently the input data is queried from Oracle database and set in POJO classes.
Dynamically show data from current selection in slicer till max year in data.
Hello Community! I have a business requirement where I have to show data as follows- Suppose I have year slicer, when I select a year from the slicer then it should show data from selected year till current year (i.e 2017) in this case. Value will be added up in each row as shown. If I select 2017 then it should show only 2017-18 data. It should be dynamically changing with the year selected in the slicer till max of year. Can anyone help and guide me in this? Thanks in advance!Count of Occurrences of a measure
In PowerBI, I am trying to figure out how to perform a count of stores based upon the percentage groups PCNT_Measure = DIVIDE(SUM('Table'[Visit]), SUM('Table'[Schedule])) For example, if all 4 months are selected The desired result would be: 100% = 3 stores 75% = 1 store 50% = 2 stores This count/percentage would then change if different months were selected. For example, if only months 1 through 3 were selected... ...then the count would be: 100% = 3 stores 66.7% = 3 storesRolling values per category
I need help with DAX. I have this table: business unit year_month category amount amount all categories 12 month rolling sum 12 month rolling sum all categories 12 month mov avg % PS 202206 A 4 10 4 10 40% PS 202207 A 6 9 10 19 53% PS 202208 A 6 10 16 29 55% PS 202209 A 3 4 19 33 58% PS 202210 A 9 18 28 51 55% PS 202211 A 3 7 31 58 53% PS 202212 A 0 0 31 58 53% PS 202301 A 5 12 36 70 51% PS 202302 A 11 21 47 91 52% I have filtered Year-month >= 202206 because column category is blank before this date. I have filtered on 1 business unit and 1 category, but there are more in de dataset. Amount all category = amount of all categories in business / year-month. I have a date table. I need the Dax formula for the 12 month rolling sum. This is wat I have thus far: 12 month rolling sum = var amount = COUNT('Table'[category]) Return CALCULATE (amount, DATESINPERIOD (Calendar[DATE],LASTDATE ( Calendar[DATE] ),-365,DAY)) But it gives my the same as column amount.Visualization of a Data Matrix in a Pie Char
Hello, It would be perfect, if somebody can help me. I have following Information (Picture 1) and I want to display that in an Pie Chart. Is it possible to visualize that, also if one project has two or more of these characteristics ? At the moment I do not know how to visualize that. Thanks and kind regards Sandro
Previous Year YTD (Cluster Column Chart)
My PY Encounters is showing the total (JAN - DEC) value for all months in cluster column chart: I need it to show the correct amount per month here is the DAX: Encounters_PY = CALCULATE( [Encounters], FILTER( ALL('Date - Service'), YEAR('Date - Service'[CalendarDate]) = YEAR( MAX( 'Date - Service'[CalendarDate]) )-1 ), ALL ( Scenario[Description] ) ) Can anyone please help me? Thanks in advance.
