Relative Content

Tag Archive for powerbipowerbi-desktop

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 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.

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.