Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I made a switch function that gives me the status of our machines ->
Hi there.
As far as I know, you can use a SQL query as a source for your tables. Here's the query that you should use:
SELECT
t.Status,
t.StatusOrder
FROM (
VALUES
('Red', 1),
('Amber', 2),
('Green', 3)
) AS t([Status], [StatusOrder])
Since it does not require any tables from your database, it should work OK. [StatusOrder] is there to be able to sort the statuses correctly, not alphabetically. When you press Get Data, you'll select the source to be your SQL Server, then you'll expand the section Advanced and input your query in the box. Easy. I've checked it and it works.
Hi daxer,
Thanks for your feedback. Unfortunatelly, i dont have access to SQL.
My challenge is to build the slicer based only on calculated measures. 😕
Hi daxer,
I have a pre-set query from HANA, i just pick a table from there. does that make it clear for you?
Alright, thanks!
@Anonymous , I think in direct query you add table using enter data. It changes the mode to mix.
rest of the approach will be like https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
Hi amitchandak,
Thanks for your feedback! Unfortunatelly, i cannot "enter data", this option is greyed out to me.
For the suggested approach, i would need to create a diconnected table, which i cannot do due to the direct query.
Any other ideas to solve my issue?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |