Dynamic Dax Measure
Hi guys, I am working on a dynamic dax measure which I like to use for one visual. Basically I want to have one visual that shows the costs. Based on the dynamic filter which I put into the x-axis field, the user is able to filter by various categories which come from various data sources. All are string values e.g by category, by city etc. I tried so many things but the Code just doesnt work. I dont want to create a extra table and merge all these categories inside, I just want it to work how it is. Thank you in advance! DynamicMeasureNEW = VAR SelectedColumn = SELECTEDVALUE(DynamicTable[Column1]) RETURN SWITCH ( SelectedColumn, "Delay Reason", VALUES(MedicallyFitForDischarge[FIT_REASON]), "Care Group", VALUES(Look_New_Trust_Hierarchy[CARE_GROUP]), "Specialty", VALUES(Look_Specialty[Specialty Description]), "Ward", VALUES(MedicallyFitForDischarge[LOCATION]), BLANK() // Return BLANK() for unmatched cases )
Permanent Filter on the PBI Report
Olá PBI' experts, eu preciso adicionar um filtro persistente do Power BI. Que os filtros que o usuário deseja, sejam salvos. Em outras palavras, os filtros aplicados por cada usuário possa ser aplicado automaticamente quando os usuários retornam para visualizar os relatórios. Então de acordo com cada usuário poderá abrir o relatório já com os filtros aplicados de acordo com sua necessidade. Isso tornaria o trabalho de cada usuário mais eficiente. Seria isso possível? Abs KleberLine Chart Not Filtering Correctly! Help!
Hi, I need some help. My line chart is not filtering when I click on a filter. Please see example below: Although one school is selected and one filter (A level) on the line chart all data is shown. The relationship is below and is active; I just want the line chart to show the filtered line, any help would be greatly appreciated! Thanks
Custom Measure not working on Pie Chart Visual
Hello Team/ Uspace87 , I have created a custom measure , which I want to use as a filter in pie chart visual. When I apply this filter , it gets applied on the "Legend" but not on the "Values" of the pie chart visual. Please assist. My exact use case is as follows : 1.The default behaviour of the checkbox slicer in Power BI is that it shows the result of OR when you select multiple items , I wanted to convert checkbox slicer to AND logic upon multiple selection. 2. I took the help of following link to create a custom measure : https://radacad.com/slicer-with-and-condition-in-power-bi 3. The custom measure is working correctly on table visual but when I try to use the same on pie chart I am facing the abovementioned issue. Please suggest if not custom measure then what is the correct way to solve my use case. Thanks DeeshaDynamic Visualization Filters
I have a forecast report and want to publish it in a BI system. But, I want the Year range to start 5 years before the year which has complete records. And I want to start the forecast line to ignore the last two years but in a filter. The reason why we wanted to use a dynamic filter instead of the usual common filters is that once the report is published, we aren't gonna have access to it. Can you give me ideas on how I can create a dynamic filter for my visualization?
