Forum Discussion
Help with visual KPI creation
Hello Experts,
Can you explain the step-by-step procedure for creating a KPI visual for the following data?
| Period | Sales Forecasting | Current Rooms | Technology % Forecast | Tech % Current |
Hi Syndicate_Admin ,
First of all, many thanks to for your very quick and effective replies.
Based on my testing, please try the following methods:
1.Create the simple table.
2.Drag the Period field into the slicer visual.
3.Create the new measure to calculate current sales.
Current per = var _select = SELECTEDVALUE('Table'[Period]) VAR _curren = CALCULATE(SUM('Table'[Current Sales]), FILTER('Table', 'Table'[Period] = _select)) RETURN _curren4.Create the new measure to calculate forcast sales.
Forcast per = VAR _per = SELECTEDVALUE('Table'[Period]) VAR _forca = CALCULATE(SUM('Table'[Sales Forecasting]), FILTER('Table', 'Table'[Period] = _per)) RETURN _forca5.Drag the measure into the KPI visual.
6.Select the period on the slicer visual. The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi Syndicate_Admin ,
First of all, many thanks to for your very quick and effective replies.
Based on my testing, please try the following methods:
1.Create the simple table.
2.Drag the Period field into the slicer visual.
3.Create the new measure to calculate current sales.
Current per = var _select = SELECTEDVALUE('Table'[Period]) VAR _curren = CALCULATE(SUM('Table'[Current Sales]), FILTER('Table', 'Table'[Period] = _select)) RETURN _curren4.Create the new measure to calculate forcast sales.
Forcast per = VAR _per = SELECTEDVALUE('Table'[Period]) VAR _forca = CALCULATE(SUM('Table'[Sales Forecasting]), FILTER('Table', 'Table'[Period] = _per)) RETURN _forca5.Drag the measure into the KPI visual.
6.Select the period on the slicer visual. The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
