I need to make available in a dashboard where there is the possibility of the user imputing information and this information will interact with a measure and that finally this measurement will be displayed in graphical, for example:
I have a measure where I present the value of the sales target for that year based on what was sold in the previous year, for example, 2016 was sold 1 million and the target for 2017 is 1.5 sales, in this case an increment Of 50%, but this increment is not a fixed value and who determines this is the user, today he wants to apply a goal of 50% tomorrow he may want to apply a goal of 10%, and to be doing it in the database is not feasible .
Is there any object in power bi where the user can enter the information and that information be stored in a variable and that variable be used in a measure?
Solved! Go to Solution.
The alternative way I'm usign is "What if parameter"+ "Measurement".
Below is my example: User manually input currency rate(USD- Taiwan Dollor), and the USD list price will be changed accordinly.
Currently there's no way to truly get user input.
There's an Idea about it though
You can kind of simulate this with a parameter table and Slicers but it will not be really user input (more like user choice)
EDIT: Okay I found the link to my previous post showing the paramter table option...
Okay, I figured I did not have this feature even if I do with the filter features as an employee? Would I apply the filter field with the percentage in measure?
I believe I would have to create a field with the possible percentages the user would use.
Thanks for the link, I am trying to apply something similar in power bi, but it is not working as expected, would you have some example of this link applied in power bi?
To see an example go to the bottom of the page at the above link where it says Downloads
Download the Excel 2013 zip files - extract all
Then Open PBI - File - Import - Excel Workbook Contents - Select ParametersTable - Multiple - Excel 2013.xlsx - Open
click Start on the warning "We don't work directly with Excel... blah blah..." - Copy Data - Migration Completed - Close
Save the File as pbix - you may have to close and open it again
Now create a Matrix - place Product in the Rows and SalesAmount and DiscountedSalesAmount in the Values (Sales table)
then create a Slicer with the field from the Discounts table - select any value from the slicer and see how the Measure reacts!
Hope this helps!
I loaded the tables but I did not find a way to relate them to the .xls data and even then I'm trying to adapt the following measure to the table that has the% information, but I'm not getting any tips
Meta Liquidação2 =
FILTER ( ALL ( Fatos ); Fatos[Ano_ID] = MAX ( Fatos[Ano_ID] ) - 1 );
Fatos[Vl_Liquidado] - Fatos[Vl_Devolvido]
TabelaMeta should not be related to any other table! Then create a Slicer with the TabelaMeta[%] column
in the Measure below you'll multiply times the other column TabelaMeta[%Valor]
So if anything in the Slicer is selected - you'll multiply the result of SUMX times the value selected in the Slicer
if nothing is selected you'll just get the result of SUMX
Meta Liquidação2 = IF ( HASONEVALUE ( TabelaMeta[%] ); SUMX ( FILTER ( ALL ( Fatos ); Fatos[Ano_ID] = MAX ( Fatos[Ano_ID] ) - 1 ); Fatos[Vl_Liquidado] - Fatos[Vl_Devolvido] + Fatos[Vl_DevolucaoCancelada] - Fatos[Vl_LiquidacaoCancelada] ) * VALUES ( TabelaMeta[%Valor] ); // this will only calculate the % SUMX ( FILTER ( ALL ( Fatos ); Fatos[Ano_ID] = MAX ( Fatos[Ano_ID] ) - 1 ); Fatos[Vl_Liquidado] - Fatos[Vl_Devolvido] + Fatos[Vl_DevolucaoCancelada] - Fatos[Vl_LiquidacaoCancelada] ) )
You may have to adjust this part
* VALUES ( TabelaMeta[%Valor] ); <= calculates only the %
* ( 1 - VALUES ( TabelaMeta[%Valor] ) ); <= discount applied
* ( 1 + VALUES ( TabelaMeta[%Valor] ) ); <= premium added
Hope this helps!
Thanks for the help, it worked, but only one error occurs when I select the values of 20% or more, the graph line is below the real value, and it should stay above as the other values of 15% or less, the Non-graphic value when selected is correct but the line display is incorrect.
We are excited to announce the Power BI Super Users!
Overview of Power BI 2020 release wave 2!
Mark your calendars and join us for our next Power BI Dev Camp!.
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.