How to Sum by field on different table
I’m trying to create a measure that will Sum the forecasted and actual proceeds a client receives for all of the companies they own. Data model is structured in a star schema with Clients as the fact table and all other tables as dimensional.
Dynamic selection of columns that are to be displayed in a matrix in Power BI Dashboard
I would like to create a dashboard where the users of the dashboard are able to select the dimension columns and fact columns that they want to see the values for, and these should appear on the dashboard as a matrix to be able to view the values for the chosen columns.
The list of dimension columns and fact columns are to be displayed as two separate multi-select slicers.
Not to show/hide values in second slicer based on first Slicer
How can we hide values which are less than in second slicer based on selected value in first slicer
Ex: If user select value 6 in first slicer then in second slicer values need to apper only >=6 (i.e 6,7,8,9,10,11,12) , remaining values from 1-5 should be hide or make user not able to click.
Both slicers are coming from 2 different tables
First Slicer values from 1 to 12
Second slicer Values from 1 to 12.
Slicer-1
How to count results after advanced filtering
enter image description here
When i selected the advanced filtering, this statistic has not changed and still shows the total number.
How do I create a clustered column chart that records data from last week, two weeks ago, and last year in PowerBI
enter image description hereI am new to PowerBi and I am trying to create a graph that shows the data of different products sold over different periods of time. I have included a picture of the exact graph I am trying to design that I previously made in google sheets. The graph needs to show how many orders of each product type were received in the designated time period; Last Week, 2 Weeks Ago, and Last Year. I am not sure how to pull data from the same table but from a different time period onto the same bar graph.
Maintaining data types after loading db columns
I have a table in our serverless SQL endpoint which is approx 300 columns. I want to load half of them with maintained data types
How do I present a measure based on parameters on different page?
I am working on a report in Power BI. I have defined some model parameters on page 1. With these parameters I created some calculated measures, for example:
Power BI: How do I present a measure based on parameters on different page?
I am working on a report in Power BI. I have defined some model parameters on page 1. With these parameters I created some calculated measures, for example:
inc = CALCULATE( COUNTROWS (table1), FILTER(table1, table1[tr1] >= par1[ tr1 Value ] && table1[tr2] >= par2[ tr2 Value ] ))
I present the results of this measure (1 or nothing) on another page. However, now when I change the values in the parameters, my results on page2 do not change with that.
What does it mean by Power BI report references a row with RLS?
Keep in mind that if a Power BI report references a row with RLS
configured then the same message displays as for a deleted or
non-existing field. To these users, it looks like the report is
broken.
Power bi matrix is repeating headers
I have a Dimension table with the following data: