Visualize one variable twice but with different filters
Hi everyone, I want to illustrate the number of beneficiaries of different interventions (1-5). I have one variable that equals the total number of beneficiaries, and I would like to visualize the number of beneficiaries of intervention 1 in the same graph (e.g. bar chart) as the number of beneficiaries of intervention 2, 3 and so on. To get the correct values I can select the interventions respectively as a filter on the beneficiaries variable, but I can only insert this variable of total beneficiaries once per graph. How can I visualize the same variable but with different filters on in the same graph? Thanks!
SharePoint - Integrate List to Power BI - Visualize List - not showing all fields
I have several sharepoint list that I'd like to visualize with Power BI. I'd like to use the Visualize List feature in Sharepoint as a quick way to build a simple dashboard within the list. When I attempt to build the report only a few fields show up in the dataset. One list it is the first 9 fields available, on the other it is a random 9. Ironically, this morning I attempted the same thing that wasn't working for months and found all 25 fields in the dataset showing but when I started to edit the report it reverted back to the 9 that was originally provided. Does anyone else have this issue or can help identify a solution. Details: -SharePoint Tennent has Power BI integreation enabled -I am running Power BI Pro -I have full read/write access to the data